View All Docs
Hide 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.

Setting up the step

Use the file selector to select which file to pull data from

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 the file name.

You can also select to skip rows or columns of your choosing. This will skip rows from top-down and columns from left-to-right.

Helpful tips

  • This step pulls data in exactly as it is shown in your Google Sheet. Formatted dates and numbers will be pulled in and shown in their formatted state. Visual formatting, such as colors, font changes, or sizing will not show up in Parabola.
  • 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.
  • This step can access any file in any Drive that your Google account has authorization to access.
  • Google Sheets is unable to parse names that contain colons. Replace colons in the name of the sheet with an underscore or period to remove any colons.
  • Other teammates who have access to a Flow where you have authenticated your Google account will not be able to see any other files in your Google Drive. If they want to update the file that the step is using, they will need to authenticate and select a file from their own Google Drive.

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.

Setting up the step

Select how you want this step to export data:

  • Add data to an existing file (by overwriting the file or appending data to the bottom)
  • Create a new file to write data to
  • Create a new file on every run

Once you’ve selected a file to add data to, or have created a new file, select a sheet to send data to (one for each input to the Send to Google Sheets step).

When creating a new file or creating a new file on every run, you can select to create that file in the root of your Drive, or within a specific folder.

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.
  • This step can access any file in any drive that your Google account has authorization to access.
  • Google Sheets has a 10 million cell limit. Any data being sent through a Send to Google Sheets step will need to be within that cell limit.
  • Other teammates who have access to a Flow where you have authenticated your Google account will not be able to see any other files in your Google Drive. If they want to update the file that the step is using, they will need to authenticate and select a file from their own Google Drive.