View Navigation
Product Overview
Account Overview
Integrations
Transforms
Security
Integrations   ->

Pull from Google Sheets

The Pull from Google Sheets step gives you the ability to pull in datasets from your Google Sheets files.

Connect your Google Sheets account

To connect your Google Sheets account, click Authorize to login with your Google account credentials.

Custom settings

Under Files, select a Google Sheets file to pull in.

If you have multiple dataset sheets (tabs) in a file, specify which one you'd like to pull in by clicking on the dropdown menu under Sheet.

In the "Advanced Settings", you can select to skip rows or columns of your choosing. This will skip rows from top-down and columns from left-to-right.

Helpful tips

  • Any changes you make to the dataset Google Sheet file will be automatically updated when you run a flow, or manually updated if you click the refresh icon to the right of the step's name.
  • Currently, our Google Sheets step can only access files in your Google Drive account. It cannot access files in a shared team Drive. Please make sure to save the file to your own Drive to be able to access the file.
Integrations   ->

Send to Google Sheets

The Send to Google Sheets step gives you the ability to automate sending custom datasets to Google Sheets. You can create a new Google Sheets file or update a specific sheet by having the dataset overwrite or append (add on) to an existing file.

Connect your Google Sheets account

To connect to your Google account, click Authorize to login with your Google account credentials.

Custom settings

Under the File dropdown, decide if you want to create a new file, or overwrite or append to an existing file. If you select to Create New File, you must enter New File Name.

If you select Append to Sheet or Overwrite Sheet, select the blue button "Show Updated Results" once to get the field Input Sheet 1 to appear. This Input Sheet 1 dropdown enables you to select which sheet in your existing Google Sheets file you'd like to overwrite or append to.

Helpful tips

  • To ensure your header column titles carry over to your sheet, be sure to overwrite a sheet once. Any appending afterwards will still keep the header column titles. However, if you append to a blank sheet, header column titles won't be included in the exported data.
  • This export step can accept multiple input sources, but here are a couple useful things to know. If you want your input sources to be exported to the same sheet, use the Stack tables step to combine your data set before sending it to the Send to Google Sheets step. If you want your input sources to be exported to different sheets, you'll have the option to select the specific sheet that your inputs should send data to.
  • Anyone with access to the Google Sheet file will be able to see and use the updated datasets.
  • Currently, our Google Sheets step can only access files in your Google Drive account. It cannot access files in a shared team Drive. Please make sure to save the file to your own Drive to be able to access the file.