View All Docs
Product Overview
A down-facing caret indicating that this drawer is closed. Click to open it.
Account Overview
Integrations
A down-facing caret indicating that this drawer is closed. Click to open it.
Transforms
A down-facing caret indicating that this drawer is closed. Click to open it.
Security
A down-facing caret indicating that this drawer is closed. Click to open it.
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

  • 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.
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.
  • 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.