Google Ads + Google Sheets
Create customer lists in Google Ads from new worksheets in Google Sheets
Stay organized and save time with this efficient workflow that connects Google Sheets and Google Ads. When a new worksheet is created in Google Sheets, this automation will instantly generate a customer list in your Google Ads account. That means you can effortlessly streamline your marketing efforts and focus on other important tasks, while keeping your customer information up to date.
Stay organized and save time with this efficient workflow that connects Google Sheets and Google Ads. When a new worksheet is created in Google Sheets, this automation will instantly generate a customer list in your Google Ads account. That means you can effortlessly streamline your marketing efforts and focus on other important tasks, while keeping your customer information up to date.
- When this happens...
New WorksheetTriggers when a worksheet is created in a spreadsheet.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Customer ListCreates a customer list in Google Ads Audience Manager.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundUse Google Ads as...Required
Managed Account
Lead FormRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUse Google Ads as...Required
Managed Account
Customer ListRequired
Customer IdentifierRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google Ads as...Required
Managed Account
ResourceRequired
Dates to IncludeRequired
Limit
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Double Opt Message
Use Google Ads as...Required
Managed Account
Multiple Identifier Note
Conversion User Identifier SourceRequired
Conversion ActionRequired
TimestampRequired
Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google As...Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
Description
Message
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Campaign
Triggers whenever a new campaign is created in Google Ads.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planUse Google Ads as...Required
Managed Account
Customer ListRequired
EmailRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Description
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google Ads as...Required
Managed Account
Customer ListRequired
Customer IdentifierRequired
Message
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.StatusRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Use Google As...Required
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google Ads
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.
Related categories
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Related Zap Templates
- Create Google Sheets rows for new Google Ads leads
- Log Google Ads offline conversions from new rows in Google Sheets
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Trigger offline conversions in Google Ads with new or updated rows in Google Sheets
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Update Google Sheets spreadsheet rows to add them to Google Ads Custom Lists
- Add people to Google Ads Customer Lists from new Google Sheets rows
- Create new Google Ads contacts from new Google Sheets spreadsheets
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Add new leads in Google Ads to Google Sheets rows
- Send Offline Conversion to Google Ads for New Spreadsheet in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Send Google Ads offline conversions when new rows are added in Google Sheets
- Send offline conversions in Google Ads with new Google Sheets (Team Drive) rows
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet Row in Google Sheets
- Create spreadsheets on Google Sheets for new Google Ads leads
- Generate rows in Google Sheets for the start of new Google Ads campaigns
- Add new Google Sheets spreadsheets to Google Ads as contacts for customer list with email
- Add people to Google Ads Custom Lists for new Google Sheets rows in a team drive
- Add contacts to Google Ads customer list with email when new or updated rows are detected in Google Sheets
- Create Worksheet in Google Sheets for new lead form entries in Google Ads
- Update offline conversions in Google Ads for new or updated rows in Google Sheets
- Launch/stop new campaigns in Google Ads with Google Sheets row updates
- Update Google Sheets spreadsheet rows to add them to Google Ads Customer Lists
- Add people to Google Ads Customer Lists for new Google Sheets rows in a team drive
- Add contacts to a Google Ads customer list for new or updated spreadsheet rows (Team Drive) on Google Sheets
- Add contacts to a Google Ads customer list for new spreadsheet rows (Team Drive) on Google Sheets
- Create worksheets on Google Sheets for new Google Ads leads
- Copy worksheets on Google Sheets for new Google Ads leads
- Update Google Sheets rows with new leads in Google Ads
- Add Google Ads contacts to customer lists with new Google Sheets rows
- Add Google Ads contacts to customer lists with new or updated Google Sheets rows
- Create Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet Row(s) in Google Sheets for new lead form entries in Google Ads
- Update Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet Column in Google Sheets for new lead form entries in Google Ads
- Create Response in Google Forms for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create customer lists in Google Ads from new spreadsheets in Google Sheets
- Add new Google Sheets rows to create customer lists in Google Ads
- Create customer lists in Google Ads from new or updated Google Sheets rows
- Update Google Ads app extensions with new or updated rows from Google Sheets
- Create spreadsheets in Google Sheets from new campaigns in Google Ads
- Create new Google Sheets worksheets for new Google Ads campaigns
- Create a copy of worksheet in Google Sheets for new campaigns in Google Ads
- Format rows in Google Sheets for new campaigns from Google Ads
- Create new extensions in Google Sheets when new lead form entries appear in Google Ads
- Update rows in Google Sheets when new lead form entries are detected in Google Ads
- Create Google Sheets extensions for each new Google Ads campaign
- "create spreadsheet columns in Google Sheets for new campaigns in Google Ads"
- Create multiple rows in Google Sheets for every new campaign in Google Ads
- Create reports in Google Ads from new rows in Google Sheets
- Update spreadsheet rows in Google Sheets when new campaigns are launched in Google Ads
- Update Google Sheets rows with new Google Ads campaigns
- Delete rows in Google Sheets when new lead form entries occur in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Generate multiple rows in Google Sheets for every new lead form entry in Google Ads
- Add new Google Ads leads to a Google Sheets worksheet
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Update Google Sheets rows with new Google Ads leads form entries
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create worksheets in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Add new Google Ads leads to multiple Google Sheets rows instantly
- Add new or updated Google Sheets rows to Google Ads contact list
- Add new Google Sheets rows to Google Ads contact list with email
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Copy new Google Ads lead form entries to Google Sheets worksheets
- Set campaign status in Google Ads for new rows in Google Sheets
- Copy new Google Ads lead form entries to Google Sheets worksheets
- Create Google Ads customer list from new or updated Google Sheets rows on team drive
- Clear spreadsheet rows in Google Sheets when new campaigns are created in Google Ads
- Clear spreadsheet rows in Google Sheets when new lead form entries occur in Google Ads
- Create spreadsheet columns in Google Sheets for new lead form entries in Google Ads
- Create new rows at the top of a Google Sheets spreadsheet for every new lead form entry in Google Ads
Related Zap Templates
- Create Google Sheets rows for new Google Ads leads
- Trigger offline conversions in Google Ads with new or updated rows in Google Sheets
- Add people to Google Ads Customer Lists from new Google Sheets rows
- Add new leads in Google Ads to Google Sheets rows
- Send Google Ads offline conversions when new rows are added in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet Row in Google Sheets
- Add new Google Sheets spreadsheets to Google Ads as contacts for customer list with email
- Create Worksheet in Google Sheets for new lead form entries in Google Ads
- Update Google Sheets spreadsheet rows to add them to Google Ads Customer Lists
- Add contacts to a Google Ads customer list for new spreadsheet rows (Team Drive) on Google Sheets
- Update Google Sheets rows with new leads in Google Ads
- Create Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet in Google Sheets for new lead form entries in Google Ads
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Create customer lists in Google Ads from new or updated Google Sheets rows
- Create new Google Sheets worksheets for new Google Ads campaigns
- Create new extensions in Google Sheets when new lead form entries appear in Google Ads
- "create spreadsheet columns in Google Sheets for new campaigns in Google Ads"
- Update spreadsheet rows in Google Sheets when new campaigns are launched in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Add new Google Ads leads to a Google Sheets worksheet
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Add new Google Sheets rows to Google Ads contact list with email
- Set campaign status in Google Ads for new rows in Google Sheets
- Clear spreadsheet rows in Google Sheets when new campaigns are created in Google Ads
- Create new rows at the top of a Google Sheets spreadsheet for every new lead form entry in Google Ads
- Log Google Ads offline conversions from new rows in Google Sheets
- Send Offline Conversion to Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Create new Google Ads contacts from new Google Sheets spreadsheets
- Send Offline Conversion to Google Ads for New Spreadsheet in Google Sheets
- Send offline conversions in Google Ads with new Google Sheets (Team Drive) rows
- Create spreadsheets on Google Sheets for new Google Ads leads
- Add people to Google Ads Custom Lists for new Google Sheets rows in a team drive
- Update offline conversions in Google Ads for new or updated rows in Google Sheets
- Add people to Google Ads Customer Lists for new Google Sheets rows in a team drive
- Create worksheets on Google Sheets for new Google Ads leads
- Add Google Ads contacts to customer lists with new Google Sheets rows
- Create Spreadsheet Row(s) in Google Sheets for new lead form entries in Google Ads
- Create Spreadsheet Column in Google Sheets for new lead form entries in Google Ads
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Create customer lists in Google Ads from new spreadsheets in Google Sheets
- Update Google Ads app extensions with new or updated rows from Google Sheets
- Create a copy of worksheet in Google Sheets for new campaigns in Google Ads
- Update rows in Google Sheets when new lead form entries are detected in Google Ads
- Create multiple rows in Google Sheets for every new campaign in Google Ads
- Update Google Sheets rows with new Google Ads campaigns
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Clear rows in Google Sheets when new lead form entries occur in Google Ads
- Create spreadsheets in Google Sheets for new lead form entries in Google Ads
- Add new Google Ads leads to multiple Google Sheets rows instantly
- Create spreadsheet rows in Google Sheets for new lead form entries in Google Ads
- Copy new Google Ads lead form entries to Google Sheets worksheets
- Clear spreadsheet rows in Google Sheets when new lead form entries occur in Google Ads
- Add contacts to Google Ads customer lists from new Google Sheets rows
- Update Google Sheets spreadsheet rows to add them to Google Ads Custom Lists
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row in Google Sheets
- Send Offline Conversion to Google Ads for New Spreadsheet Row (Team Drive) in Google Sheets
- Add Contact to Customer List With Email in Google Ads for New Spreadsheet Row in Google Sheets
- Generate rows in Google Sheets for the start of new Google Ads campaigns
- Add contacts to Google Ads customer list with email when new or updated rows are detected in Google Sheets
- Launch/stop new campaigns in Google Ads with Google Sheets row updates
- Add contacts to a Google Ads customer list for new or updated spreadsheet rows (Team Drive) on Google Sheets
- Copy worksheets on Google Sheets for new Google Ads leads
- Add Google Ads contacts to customer lists with new or updated Google Sheets rows
- Update Spreadsheet Row in Google Sheets for new lead form entries in Google Ads
- Create Response in Google Forms for new lead form entries in Google Ads
- Add Contact to Customer List With Email in Google Ads for New or Updated Spreadsheet Row (Team Drive) in Google Sheets
- Add new Google Sheets rows to create customer lists in Google Ads
- Create spreadsheets in Google Sheets from new campaigns in Google Ads
- Format rows in Google Sheets for new campaigns from Google Ads
- Create Google Sheets extensions for each new Google Ads campaign
- Create reports in Google Ads from new rows in Google Sheets
- Delete rows in Google Sheets when new lead form entries occur in Google Ads
- Generate multiple rows in Google Sheets for every new lead form entry in Google Ads
- Update Google Sheets rows with new Google Ads leads form entries
- Create worksheets in Google Sheets for new lead form entries in Google Ads
- Add new or updated Google Sheets rows to Google Ads contact list
- Copy new Google Ads lead form entries to Google Sheets worksheets
- Create Google Ads customer list from new or updated Google Sheets rows on team drive
- Create spreadsheet columns in Google Sheets for new lead form entries in Google Ads