How to connect your Google Sheet to Actions
Overview
This how-to walks you through how to connect your Google Sheet data to an Action.
If you’re creating a new Action with a Google Sheet datasource, you will need to refresh your Google token (see how-to).
If you are editing an existing Action to change the datasource option to be Google Sheets, you will need to share the Google Sheet with whomever originally created the Action and have them refresh their Google token (see how-to).
Instructions
Navigate to the Set Datasource page from one of two ways:
New Action
On the Actions' homepage, click ‘Create New’.
Select your Action Type.
Name your Action, select your authenticated account, and click ‘Next’
Existing Action
On the Actions' homepage, click the name of your Action.
Click the progress tracker above ‘Set Datasource’.
Select 'Google Sheets' as your Datasource.
Add the link to your Google Sheet and name of the tab that contains your data, if you have more than one.
Ensure your Google Sheet contains the required column headers and data formats.
Click ‘Save’. Your Action is now set up to connect to your Google Sheet.
If you’re setting up a new Action, complete the set up process:
On the ‘Review Action’ page, add a schedule if needed.
Click ‘Publish’.
Actions ignores any filters applied within Google Sheets and will pull in all data. If you need filtered data, create a new tab with just the data you’d like to pass to Actions.
Related articles
- How to connect your Google Sheet to Actions
- How-to set up a one-off Action that you manually run
- How-to Test Your Action
- How To Schedule Your Action to Run
- How To Disable or Remove an Action
- How To QA Your Action Runs
- How To View Error Messages on an Action That Ran
- How To Authenticate a Partner Platform to Send Actions To
- How-To Add Locations to Campaigns in Google Ads
- How-to Pause or Activate Meta (Facebook) Ads
- How-to add Negative Mobile Placements with clicks in last 7 days in Google Ads
- How-to add negative keywords to Google Ads
- How-to apply network settings in Google Ads
- How-to set up automated Facebook Social Ad Trafficking