Google Sheets: Add New Row

gsstep

The “Google Sheets – Add New Row” step type enables users to add rows to an existing Google Spreadsheet.  This is especially useful for cases where your team may be tracking data (ex. in-flight RMA’s) from a separate more use-case specific database.

To enable the integration, first authenticate by following these steps:

From the Integrations Library

  • Find Google Sheets, and select Update
  • Google Sheets will Authenticate, click to Allow

gsupdategsconfirmed

Once the integration is enabled, add this integrated step to an existing flow:

From the Step Type Library on the Flow Builder

  • Select  Google Sheets: Add New Row to add the step to an existing Flow.

gsstep

From the step configuration you will need to enter the following information which is available by accessing the google sheet directly in a separate tab.

GSStepConfig.png

Spreadsheet ID

From the Google Sheet

  • Go to the url bar and copy the ID value between the two backslashes. Paste this value in for the Spreadsheet ID on the step configuration on BrightReps

gsdocid

Range

From the Google Sheet

  • Select Data > Named Ranges

GSDataRange.png

  • Select Add A Range

GSAddRange.png

  • Enter a Name for the Range
  • Select the Header fields to define the range

GSDefineRange.png

  • Enter the Range name into the Range field on the step configuration on BrightReps

Sheet Columns

From the step configuration on BrightReps

  • Click the Refresh icon to refresh and pull values in from the entered spreadsheet ID and Range from above.
  • This will populate a table with a row for each column option.  Enter a default value for each column to be populated with or select the PLUS (+) icon to add a dynamic variable to use by default.

SheetColConfig.png