Box + Google Sheets Integrations

How to connect Box + Google Sheets

Zapier lets you send info between Box and Google Sheets automatically—no code required.

When this happens...

New Comment

Triggered when someone comments on a file in a folder you own/collaborate on.

automatically do this!

Copy Worksheet

Create a new worksheet by copying an existing worksheet.

Popular Box + Google Sheets workflows

Our most popular Zap! arrow pointing down

List new Box files in a Google Sheets spreadsheet
Box + Google Sheets
More details
When this happens
Step 1: New File
Then do this
Step 2: Create Spreadsheet Row
See Zap details Try it
List new Box files in a Google Sheets spreadsheet
List new Box files in a Google Sheets spreadsheet
Box + Google Sheets

Supported triggers and actions

What does this mean?

New Comment
Triggered when someone comments on a file in a folder you own/collaborate on.
Trigger
Scheduled
New Event
Triggered when a new event is performed (this is the activity stream).
Trigger
Scheduled
New File
Triggered when you add a new file to a folder.
Trigger
Scheduled
New Folder
Triggered when you add a new folder.
Trigger
Scheduled
Task Assigned to You
Triggered when you are assigned a task.
Trigger
Scheduled

Add User as Collaborator
Adds an individual user as a collaborator on a folder.
Action
Write
Add Comment to File
Adds a comment to a file.
Action
Write

Upload File
Copy an already-existing file from another service to Box.
Action
Write

Box
Creates a brand new folder at the path you specify.
Scheduled
Action
Box
Moves or copies a file from one folder to another.
Scheduled
Action
Box
Creates a brand new text (.txt) file from plain text content you specify.
Scheduled
Action
Box
Adds a task to a file.
Scheduled
Action
Box
Search for a specific file by name.
Scheduled
Action
Box
Search for a specific folder by name.
Scheduled
Action
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

How Box + Google Sheets Integrations Work

Step 1: Authenticate Box + Google Sheets.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.