Skip to main content

View to Google Sheet

Overview​

This connector is used to export data from a BuiltAPI View to a Google Sheet. Each time the pipeline is run, it will export the latest data from the View to the Google Sheet.

Prerequisites​

Before you can use this connector, you need to set up a Google Sheet:

  1. Create a Google Sheet.
  2. Share the Google Sheet with BuiltAPI service account email ([email protected]) or share with everyone with the link.
  3. Copy the Google Sheet ID from the URL. You can find the ID in the URL of your spreadsheet:
    https://docs.google.com/spreadsheets/d/{THIS_IS_THE_DOCUMENT_ID}/edit#gid=123456789

Pipeline Parameters​

Source View Settings​

Configuration options for choosing and customizing the source view.

  • Select View - Choose or create the source view from which data will be extracted.
  • View Filter - Apply Mongo filters to the source view to refine the data selection.

Google Sheet Settings​

Settings for specifying the Google Spreadsheet details.

  • Spreadsheet ID - Enter the ID of the Google Spreadsheet where the data will be exported.
  • Spreadsheet Sheet Name - Provide the name of the sheet within the Google Spreadsheet (1 to 128 characters).

Execution Settings​

Optional control parameters for pipeline execution.

  • Operation Timeout - Specify the maximum allowed execution time for the pipeline. Example: "30 min", "1800s".
  • View Record Batch Size - Specify the number of records to retrieve from the source view per batch (from 1 to 1000). This controls how many records are fetched in each iteration.