Google Sheets

Google Sheets Integrations

  • Save new Typeform entries to a Google Sheets spreadsheet

    Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

    How this Typeform-Google Sheets integration works

    1. Someone fills out a new entry for your Typeform form
    2. Zapier automatically logs that entry as a new row in a Google Sheets spreadsheet

    Apps involved

    • Typeform
    • Google Sheets
  • Create rows on Google Sheets for new Facebook Lead Ads leads

    Whether you're capturing user information for a current offer or to gauge future interest, spreadsheets are great for storage. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your social media so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you.

    How It Works

    1. Facebook Lead Ads captures a new lead
    2. Zapier automation creates a new row in Google Sheets

    What You Need

    • Facebook Lead Ads account
    • Google Sheets account
  • Save Gmail emails matching certain traits to a Google Spreadsheet

    Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: boss@work.com) and automatically save them as a new row in a Google Spreadsheet so you have them backed up and for reference later.

    How It Works

    1. Specify a search term for your Gmail emails
    2. When you have new emails that match this search, Zapier copies the message and adds it to a new row in a designated Google Sheets document

    What You Need

    • Gmail account
    • Google account
  • Create Trello cards from new Google Sheets rows

    Trying to bulk create Trello cards? Or perhaps you have a Google Form that should create Trello cards.

    Either way, this integration has your back. Automatically create new Trello cards from new rows in a Google Sheets spreadsheet or Google Form submission.

    How It Works

    1. Add a new row or form submission to a Google Spreadsheet
    2. Zapier will automatically create a new Trello card

    What You Need

    • A Google Spreadsheet
    • A Trello board
  • Send an Email via Gmail for Updated Spreadsheets

    This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column.

    How it works

    1. Add or update a row in your spreadsheet
    2. Zapier will automatically trigger an email via Gmail

    What You Will Need

    • A Google Spreadsheet account
    • A Gmail account
  • Create a Trello card from an updated or new Google Sheets spreadsheet row

    Google Sheets are a great online source for information you need as a group, and could aggregate information from a variety of sources that needs to be acted on. By automatically creating Trello cards from updated or new spreadsheet rows, you can make sure that each new input is being added to your workflow and being addressed.

    How It Works

    1. A row is created or updated in a Google Sheets spreadsheet
    2. Zapier creates a Trello card with information from that spreadsheet row

    What You Need

    • Google Apps account
    • Trello account
  • Post a new message to Slack whenever a Google Sheets row is updated

    If you use Google Sheets to collaborate with your team on spreadsheets, it can be tough to keep track of every change your coworkers make. This Zap makes it simple: it sends you a new Slack message whenever a Google Sheets spreadsheet row is updated.

    How It Works

    1. Someone adds a new row—or updates a row—in your Google Sheet
    2. Zapier alerts you by posting a message to Slack

    What You Need

    • A Google Sheets account
    • A Slack account
  • Create Google Calendar events from new Google Sheets spreadsheet rows

    Ever need to create calendar events in bulk? Or let others easily add calendar events for you? Or perhaps you just find it easier to manage your calendar in a spreadsheet.

    If so, this integration makes it easy to create new Google Calendar events straight from new rows in a Google Spreadsheet

    How It Works

    1. Add new row to your spreadsheet with details about the event.
    2. Zapier will automatically add that event to your Google Calendar.

    What You Need

    • A Google Spreadsheet
    • A Google Calendar
  • Add info to a Google Sheet from new Webhook POSTs

    Keeping an updated record of key information means you never have to wonder if there are missing or forgotten items. Set up this integration, and Zapier can catch a webhook POST from any source you want, automatically adding the information to a new row on Google Sheets once you've chosen which items go into different columns during setup. From then on, you can be sure we'll catch everything while you're free to work on other tasks.

    How this Webhook-Google Sheets information works

    1. A new webhook POST is caught by Zapier
    2. Zapier automatically adds the info you need Google Spreadsheet

    Apps involved

    • A webhook enabled-app of your chosing
    • Google Sheets
  • Save new Gravity Forms submissions to a Google Sheets spreadsheet

    Need to save your Gravity Forms submissions to a Google Sheets spreadsheet so you can easily share results with teammates and other collaborators outside of Gravity Forms? This Gravity Forms-Google Sheets integration makes it easy to do just that.

    How it works

    1. Choose an existing or new Gravity Form and Google Spreadsheet
    2. Whenever someone fills out that form, Zapier instantly copies the new record into your Google Sheets spreadsheet

    You'll be able to choose which Gravity Forms fields are pushed to your spreadsheet, and which column they end up in.

    What You Need

    • Gravity Forms WordPress plugin
    • Gravity Forms Zapier plugin
    • Google Sheets spreadsheet
  • Add subscribers to MailChimp from a Google Sheets spreadsheet

    After you set this Zap up, Zapier will automatically add new subscribers to your MailChimp list when they get added to a new row in a spreadsheet. Works great with Google Forms and Google Spreadsheets alike.

    How it works

    1. Create a spreadsheet or form to add new email subscribers to.
    2. Anytime you want a new subscriber in MailChimp make sure to add the subscriber to the next row in the spreadsheet.

    If you use Google Forms simply fill out the form and that will automatically add the subscriber to MailChimp too.

    What You Need

    1. A Google Spreadsheet setup to work with Zapier
    2. A MailChimp account with at least 1 subscriber list
  • Save new Eventbrite attendees to a Google Sheets spreadsheet

    Rather than constantly exporting CSV files, use Zapier to automatically add new attendees to a Google Sheets spreadsheet. Once you set up this Eventbrite-Google Sheets integration, new attendees from that point forward are automatically added to your spreadsheet.

    Note: This Zapier integration doesn't import already registered event attendees to your Google Sheets spreadsheet—only new attendees after you've set it up.

    How It Works

    1. Zapier keeps an eye on your event's attendee list
    2. When a new attendee registers, Zapier adds that individual's info (customizable) to a new row in your Google Sheets spreadsheet

    What You Need

    • Eventbrite account with live event
    • Google Sheets account
  • Create Google Calendar events from new Google Form entries

    This Zapier integration connects a Google Form to a Google Calendar account, automating the creation of new events.

    How It Works

    1. Zapier watches your Google Form's associated Google Sheet for new responses
    2. When a new response is received, Zapier creates a Google Calendar event

    What You Need

    • The Google Sheet of a Google Form (where you results are compiling)
    • Google Calendar account
  • Add new incoming Gmail emails that match a label to Google Sheets as new rows

    Email inboxes are great for viewing conversations, while spreadsheets make it easy to manipulate and store data. Get the best of both worlds for your emails with this Gmail-Google Sheets integration by Zapier!

    Set it up and we'll watch Gmail for you, triggering the automation with every new email you label and adding its data to a new row on Google Sheets to build a per-label index of your messages.

    How It Works

    1. A new label is added to an email on Gmail
    2. Zapier automation creates a new row on Google Sheets

    What You Need

    • Gmail account
    • Google Sheets account
  • Send new parsed emails to Google Sheets as new rows

    Keep track of every email you send to the Zapier Email Parser by letting Zapier save data from each to Google Sheets. Triggered with each email your Parser mailbox receives, this Zap will automatically send the information extracted according to your rules and add new rows to Google Sheets every time.

    Note: This is an advanced Zapier function that relies on previously set up Parser mailboxes. You can sign up for Parser and learn more about how it works on the Parser homepage.

    How it Works

    1. A new email is received by your Email Parser mailbox
    2. A new row is added on Google Sheets

    What You Need

  • Create new Google Sheets row from a new Google Calendar event

    There may be times when you need to catalog events from your calendar, and a spreadsheet can be a great way to do that. Zapier will automatically create a new Google Sheets row for every new event you create in Google Calendar.

    How It Works

    1. A new Google Calendar event is created.
    2. Zapier adds that event in Google Sheets as a new row.

    What You Need

    • Google account
  • Save new Trello card activity as Google Sheets rows

    Keep track of your Trello card activities in a Google Sheets spreadsheet for easier refrence for what's happening in projects. This Trello Google Sheets integration makes it a breeze to save new Trello activity to a new row in a Google Spreadsheet.

    Note: This Zapier integration only adds rows for Trello card activities that happen after you've set it up.

    How It Works

    1. A new activity happens in Trello.
    2. Zapier adds a new row to a Google Sheets spreadsheet

    What You Need

    • Trello account
    • Google Sheets account
  • Add Slack messages to a Google Sheets spreadsheet

    Want a quick way to add data to a Google Sheets spreadsheet? Make a dedicated Slack channel for your spreadsheet, then setup this integration, and whenever a new message is posted to the Slack channel, Zapier will copy it into a new row in your spreadsheet. It's the quickest way to gather data from your team—or to create an archive of everything posted to your Slack channel.

    How It Works

    1. Post a new message to a channel in Slack
    2. Zapier will copy the message into a new row in a Google Sheets spreadsheet

    What You Need

    • Google account
    • Slack account
  • Find and update existing Google Calendar events when Google Sheets rows are updated

    Plans often change, so your calendar events should too. This integration automatically finds existing Google Calendar events and updates them with new information from Google Sheets. If the event you're looking for doesn't yet exist, it will be created. That way, if an event is changed, your calendar will automatically reflect the change.

    How this Google Sheets-Google Calendar integration works

    1. A row is updated in Google Sheets
    2. Zapier finds an existing Google Calendar event (or creates one if it doesn't already exist)
    3. Zapier updates the existing Google Calendar event

    Apps involved

    • Google Sheets
    • Google Calendar
  • Add new ClickFunnels orders to Google Sheets

    Do you need a way to provide ClickFunnels order data to your fulfillment center? Why not use a shared Google Sheet? Zapier can help you connect the two and keep everyone on the same page.

    Note: This Zapier integration will not add existing order information to your Google Sheet. Only new orders will be added.

    How It Works

    1. An order gets placed in ClickFunnels
    2. Zapier creates a new row in your Google Sheet with the specified order information

    What You Need

    • ClickFunnels account
    • Google Drive account
  • Save new MailChimp subscribers to a Google Sheets spreadsheet

    Save your new MailChimp subscribers to a Google Sheets spreadsheet so that it's easier to share your list with teammates. This MailChimp Google Sheets integration will automatically add new MailChimp subscribers to a new row in a Google Spreadsheet.

    Note: This Zapier integration only saves subscribers that are created in MailChimp after the integration is set up.

    How It Works

    1. A new subscriber is added to a MailChimp list.
    2. Zapier adds a new row to a Google Sheets spreadsheet.

    What You Need

    • MailChimp account
    • Google Sheets account
  • Add new Trello cards to a Google Sheets spreadsheet

    Need an easy way to share new Trello cards with teammates that don't have access to Trello? This Trello Google Spreadsheet integration will automatically add new Trello cards to a Google Spreadsheet for easy reference.

    Note: This Zapier integration only adds rows for Trello cards that are created after you've set it up.

    How It Works

    1. A new Trello card is created
    2. Zapier adds a new row in a Google Sheets spreadsheet

    What You Need

    • Trello account
    • Google Sheets account
  • Log new Gmail emails from a specific sender to Google Sheets spreadsheet

    Emails can get lost in your inbox, if you need to keep a record of emails received from a specific sender, this automation is just the ticket. After you set it up, new emails from a sender you designated will be added to a Google Sheet. That way, you'll always have a record on hand.

    *Note: This Zapier integration doesn't log emails you may have already received from the specified sender, but only new emails you receive from them after this Zapier integration has been setup.

    How this Gmail-Google Sheets integration works

    1. A new email is received from a specified sender
    2. Zapier adds new rows in Google Sheets

    Apps involved

    • Gmail
    • Google Sheets
  • Create Google Contacts from new Google Sheets rows

    Using Google Forms or Google Spreadsheets to collect and store contact data? This Google Sheets Google Contacts integration will automatically create new contacts in Google Contacts when a new row is added to your spreadsheet.

    This Zapier integration only adds new Google Contacts contacts from Google Sheets rows that are added after this integration is set it up.

    How It Works

    1. A new Google Sheets row is added
    2. Zapier creates a new contact in Google Contacts

    What You Need

    • Google Sheets account
    • Google Contacts account
  • Add Chatfuel for Facebook cards with new Google Sheets rows

    A spreadsheet is a powerful and easy way to store content for your plugins. But that doesn't mean you have to copy it over yourself. After you've set up this integration, it will trigger with every new row you add to a specific row on Google Sheets. Zapier will then copy the details over to Chatfuel for Facebook, adding them to your plugin in a new card.

    How this Google Sheets -Chatfuel for Facebook integration works

    1. A new row is added to a file on Google Sheets
    2. Zapier adds a new card to Chatfuel for Facebook

    Apps involved

    • Google Sheets
    • Chatfuel for Facebook

Why Zapier?

Free

Get started for free—14 day trial of premium features and apps.

Easy

No coding required—automate any of 1,000+ apps in minutes.

Secure

Enterprise-level security—connect mission-critical apps.

Google Sheets Integration Details

Launched on Zapier September 12, 2014

Being able to collect, track, and analyze your data is essential for any business. Using Google Sheets with Zapier, you can automatically create and edit spreadsheets with data from other apps you use. Zapier can monitor changes in your Google Sheets and quickly share your important data with stakeholders. When you put Zapier to work with Google Sheets, you can connect Google Sheets to other apps, automating all of your spreadsheet tasks to save you time.

Here are some creative ways to use Google Sheets with Zapier:

  • Quickly share customer inquiries from your web forms with your sales team through Google Sheets. Use Zapier to save new entries you receive from Wufoo forms, SurveyMonkey questionnaires, and other forms right to Google Sheets.
  • Streamline how your team logs and reports bugs. Send an email to your dev team when you create a new row with error info in a Google Sheets spreadsheet.
  • Keep your team in the loop by posting a message in Slack when a Google Sheets spreadsheet is updated.

Zapier combines Triggers (like "New Spreadsheet Row") and Actions (like "Create Spreadsheet Row") to complete an action in one app when a trigger occurs in another app. These combos—called "Zaps"—complete your tasks automatically.

The following Google Sheets Triggers, Searches, and Actions are supported by Zapier:

Create Spreadsheet Row

Create a new row in a specific spreadsheet.

Update Spreadsheet Row

Update a row in a specific spreadsheet.

Create Spreadsheet Row(s)

Create one or more new rows in a specific spreadsheet (with line item support).

Create Spreadsheet Column

Create a new column in a specific spreadsheet.

Delete Spreadsheet Row

Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.

Create Spreadsheet

Create a blank spreadsheet with a title. Optionally, provide headers.

New Spreadsheet Row

Triggered when a new row is added to the bottom of a spreadsheet.

New or Updated Spreadsheet Row

Triggered when a new row is added or modified in a spreadsheet.

New Worksheet

Triggered when you create a new worksheet in a spreadsheet.

New Spreadsheet

Triggered when you create a new spreadsheet.

Lookup Spreadsheet Row

Finds a row by a column and value. Returns the entire row if one is found.

Find Many Spreadsheet Rows (With Line Item Support)

Finds many matched rows (10 max.) by a column and value.

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.