ConditionalVisibility

new-products-promo

Automation inspiration

automate-spreadsheets-00-hero

Google Sheets

Airtable

Microsoft Excel

Spreadsheets can do a lot more than help you keep track of data. Add automation and they can update themselves, send information to your team or customers, and help you scale your workflows.

7 ways to automate spreadsheets | Zapier

With automation, your spreadsheets can do a lot more than help you keep track of data. They can update themselves, send information to your team or customers, and help you scale your workflows.

7 ways to automate spreadsheets

Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads 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. Learn more in our 

Facebook lead ads make signing up for business information easy for people and more valuable for businesses. The Facebook lead ad app is useful for marketers who want to automate actions on their leads.

Facebook Lead Ads

New Lead

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

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

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

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

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

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

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

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

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

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add new Facebook Lead Ads leads to rows on Google Sheets

If you're looking for an efficient way to keep your prospects organized, this integration can help! As soon as a new lead is generated in Google Ads, this Zap automatically adds their details to a row in a specified Google Sheets spreadsheet.

Google Ads (formerly Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.

Google Ads

Triggers whenever a new campaign is created in Google Ads.

New Campaign

Triggers whenever a new lead is created from a Lead Form Extension.

New Lead Form Entry

Finds a Google Ads Campaign whose id matches the provided input.

Find Campaign by Id

Finds a Google Ads Campaign whose names matches the provided input.

Find Campaign by Name

Find Customer List

Finds a customer list by name. Optionally creates a new customer list.

Find or Create Customer List

Adds a contact to a customer list using their email address. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List With Email

Adds a contact to a customer list. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Add Contact to Customer List

Creates a customer list in Google Ads Audience Manager.

Create Customer List

Creates a report on specified data from your campaigns/ads.

Create Report

Remove Contact From Customer List

Sends events from your customer systems (PoS, CRM, email service provider, etc) to connect Google Ad campaigns to offline activity and business impact.

Send Offline Conversion

Sets the status of a Google Ads campaign.

Set Campaign Status

Create Google Sheets rows for new Google Ads leads

Once you set up this integration you will automatically get every lead from TikTok added to your Microsoft Excel sheet. No longer will you need to manually download your leads.

TikTok's Lead Generation enables businesses of all sizes to create seamless interactions to reach prospects in order to convert them into potential customers.

TikTok Lead Generation

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. 

Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Triggers when a new row is added to a worksheet in a spreadsheet.

New Row

Triggers when a new row is added to a table in a spreadsheet.

New Row in Table

Triggers when a new worksheet is added to a spreadsheet.

Triggers when a row is added or updated in a worksheet.

Updated Row

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

Find Row

Finds any rows that match a specific value in a given column.

Find Row(s)

Adds a new row to the end of a worksheet.

Add Row

Adds one or more rows to the end of a worksheet (with line item support).

Add Row(s)

Adds a new row to the end of a specific table.

Add Row to Table

Update Row

Add new TikTok Lead Generations leads to Excel

Your time is best spent nurturing new prospects, not on data entry. Set up this integration to automatically save information submitted by new leads to your LinkedIn Lead Gen Form to a new row in a specified Google Sheets spreadsheet. Sort and filter through them at will, while saving time and effort! 

LinkedIn Ads allows marketers to collect even more quality leads from their ads and events on LinkedIn with seamless pre-filled forms.

LinkedIn Ads

Triggers when you receive a new form response tied to a Company Page, Product Page, or Event.

New Lead Gen Form Response (Organic Content)

Triggers when you receive a new form response for an ad.

New Lead Gen Form Response (Sponsored content)

Add Company to Audience

Add Contact to Audience

Creates an Audience that you can add Contacts or Companies to.

Create Audience

Sends a Conversion Event to a Conversion.

Send Conversion Event

Removes an email address from an Audience.

Remove Email from Audience

Add new  leads in LinkedIn Ads to Google Sheets rows

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.

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Webhooks by Zapier

Retrieve Poll

Wait for a new POST, PUT, or GET to a Zapier URL.

Catch Hook

Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.

Catch Raw Hook

Fire off a custom request by providing raw details. Very flexible but unforgiving.

Custom Request

Fire off a single GET request with optional querystrings.

Fire off a single POST request as a form or JSON.

POST

Fire off a single PUT request as a form or JSON.

Add info to a Google Sheet from new Webhook POST requests

If you keep track of information on Google Sheets and want to send a webhook whenever a new row is added, Zapier can do that for you. Select a spreadsheet, and Zapier will automatically send a webhook whenever a new row is added.

Send webhooks when new rows are created in Google Sheets

You know that important data is going to end up on a spreadsheet, so why not connect your webhooks to it in the first place? During set-up, this Zap will provide you with a custom webhook URL. Direct your webhook traffic to it and we'll do the rest, catching each payload and entering the data automatically on a new Excel row for you.

Create a spreadsheet row in Microsoft Excel from a webhook

Webhooks enable a huge variety of sources to receive data—and now that can come from Excel automatically as well. Set up this Zapier integration and we'll take care of the rest: For each new row you add on Excel, we'll make a POST to any webhook URL you need, passing the data along so your pipeline is never slowed down because of manual entry.

POST new Excel rows to a webhook 

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

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

Trello

New Board

New Card

Triggers when a Card is archived in Trello.

New Card Archived

Triggers when a Comment is added to a Card in Trello.

New Comment in Card

Triggers when there is activity in Trello.

New Activity

Triggers when a Card is moved to a List in Trello, [inside the same Board](https://zapier.com/apps/trello/help#common-problems-trello#not-triggering-on-card-moved-to-list-when-a-card-is-moved-from-another-board).

Card Moved to List

Triggers at a specified time before a card is due.

Card Due

Triggers when a Card is updated in Trello.

Card Updated

Triggers when a new checklist is created in Trello.

New Checklist

Triggers when a new label is created in Trello.

New Label

Triggers when a label is added in a Trello card.

New Label Added to Card

Triggers when a new list on a board is added.

New List

Triggers when a new member joins a board.

New Member on Board

Triggers when you get a new notification in Trello.

New Notification

Finds a label on a particular board by name.

Find Label on Board

Finds a list on a particular board by name.

Find List on a Board

Finds a checklist on a particular board or card by name.

Find Checklist

Finds a checklist item on a particular checklist by name.

Find Checklist Item

Finds a board in your Trello organization by name.

Find Board

Finds a card in your Trello organization by name, given a specified board and list. Does not search archived cards.

7 ways to automate spreadsheets

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.