Skip to content

Connect Box and Google Sheets to unlock the power of automation

  • No credit card required
  • Free forever for core features
  • 14-day trial for premium features and apps
Choose a Trigger
Choose an Action
Google Logo Start with Google for free

Top companies trust Zapier to automate work that solves their unique business problems—no coding required.

How Zapier works

Zapier makes it easy to integrate Box with Google Sheets - no code necessary. See how you can get setup in minutes.

100%
Help
Box logo
Box
Box logo
Box
1. Choose trigger event
Google Sheets logo
Google Sheets
Google Sheets logo
Google Sheets
2. Choose action
Box logo
1. Select the event
Setup
Test
Box logo
Box
Choose a trigger event

Choose a trigger

A trigger is the event that starts your Zap—like a "New Comment" from Box.

Add your action

An action happens after the trigger—such as "Create Spreadsheet Column" in Google Sheets.

You’re connected!

Zapier seamlessly connects Box and Google Sheets, automating your workflow.

Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023

G2 Badge - Best Est. ROI - Winter 2024
G2 Badge - Best Results - Winter 2024
G2 Badge - Most Implementable - Winter 2024
G2 Badge - Leader Mid-Market - Winter 2024

93%

Customers who say using Zapier has made them better at their job

25m

Customers have created over 25 million Zaps on the platform

6 mins

The average user takes less than 6 minutes to set up a Zap

Make work flow with AI

Level up your Box to Google Sheets integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Illustration of AI enhancing Zapier workflows with automation and app integrations.

Frequently Asked Questions about Box + Google Sheets integrations

New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Box and Google Sheets

How can I integrate Box with Google Sheets using your platform?

We offer an easy integration between Box and Google Sheets that lets you automate workflows. You can set up triggers, such as 'New File in Folder' in Box, which will automatically initiate an action in Google Sheets, like 'Create Spreadsheet Row', without needing to write any code.

What triggers are available when integrating Box with Google Sheets?

When integrating Box with Google Sheets, available triggers include 'New File', 'New Folder', and 'File Updated' in Box. These triggers can automatically prompt actions like inserting new rows or updating existing entries in your Google Sheets.

What actions can be performed in Google Sheets when a trigger is initiated in Box?

Once a trigger from Box is detected, such as uploading a new file or modifying an existing one, you can automate actions like adding a row, updating cell content, or even creating a new spreadsheet within your connected Google Sheets.

Is coding knowledge required to set up the integration between Box and Google Sheets?

No coding knowledge is necessary. Our platform is designed to be user-friendly so that anyone can set up automated workflows between Box and Google Sheets using pre-defined triggers and actions through our interface.

Can I customize the data sent from Box to my Google Sheet?

Yes, you have control over what data is sent by mapping specific fields from Box to corresponding columns in your Google Sheet. You can determine which information gets transferred based on your workflow needs.

How do I handle errors during the integration process between Box and Google Sheets?

If errors occur during the integration process, our platform provides detailed logs and error messages that help pinpoint issues. We recommend checking these logs first and re-configuring the setup if needed. Additionally, our support team is always ready to assist you.

Are there limitations to how frequently data can be synced between Box and Google Sheets?

Data syncing capabilities depend on the plan you're subscribed to. While some plans offer near real-time syncing whenever a trigger event occurs, others might be limited to checks every few minutes.

Practical ways you can use Box and Google Sheets

Track tasks assigned to you in Google Sheets.

When you're assigned a task in Box, Zapier automatically adds it to a Google Sheets spreadsheet. This ensures all tasks are consolidated in one place for better prioritization and progress tracking.

Business Owner
Try it
Log Box events in Google Sheets.

Whenever a new event is triggered in Box, Zapier automatically creates a new row in Google Sheets capturing the event's details. This enables IT teams to monitor activity, compliance, or security incidents effectively, streamlining detailed recordkeeping.

IT
Store new file information in Google Sheets.

As soon as a new file is added to a Box folder, Zapier will automatically log the file details in a Google Sheets spreadsheet. This provides a clear and up-to-date record for the project team to track file additions, ensuring everyone is on the same page.

Project Management

Supported triggers and actions

Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.

  • Box triggers, actions, and search
    New Comment

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

    Trigger
    Polling
    Try It
    • Folder
      Required
    • Share
    Trigger
    Polling
    Try It
    • File_id
      Required
    • Message
      Required
    Action
    Write
  • Box triggers, actions, and search
    Event

    Triggers when a new event is performed (this is the activity stream).

    Trigger
    Polling
    Try It
    • Email
      Required
    • Folder
      Required
    • Role
      Required
    Action
    Write
    • Folder
      Required
    • File
      Required
    • Name
    • Share
    Action
    Write

Learn how to automate Google Sheets on the Zapier blog

box logo
About Box
Box lets you keep all your businesses files in one place for simple online collaboration.
Related categories
Similar apps
Dropbox integrationsDropbox integrations
Dropbox
File Management & Storage
Google Drive integrationsGoogle Drive integrations
Google Drive
File Management & Storage, Google
OneDrive integrationsOneDrive integrations
OneDrive
File Management & Storage, Microsoft
google-sheets logo
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables integrationsZapier Tables integrations
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations
Zoho Creator
App Builder, Zoho
Smartsheet integrationsSmartsheet integrations
Smartsheet
Spreadsheets

Connect Box to Google Sheets on the world's largest no-code automation platform

Google Logo Sign up with Google