Google Sheets Integrations

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

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.

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: it will create new Google Calendar events straight from new rows whenever they're added to a Google Sheet, so you don't have to worry about adding them twice.

Note: Use this Zap template only if you're adding all the information to the row at once (from a form, for instance.) If not you'll want to use this Zap so it only triggers on updates to specific columns.

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.

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

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

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.

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

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

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

• A Zapier Email Parser account
• A Google Sheets account

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

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

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

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

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 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

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

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

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

You might need to share new contacts created in ClickFunnels with other people, or you might have a different metric to track. This Zapier integration makes it easy to add new ClickFunnels contact data to Google Sheets. You can transfer as much contact data as you need, and you can easily see your new ClickFunnels contacts in Google Sheets.

How this ClickFunnels-Google Sheets integration works

1. A new ClickFunnels contact is created
2. Zapier adds the contact data to a row in Google Sheets

Apps involved

• ClickFunnels
• Google Sheets