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.
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](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a48a6f553cccf8497c8_gsstep.png)
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](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a539acd5075d954b175_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](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a53a6f55318dc8497cd_gsdocid.png)
Range
From the Google Sheet
- Select Data > Named Ranges
![GSDataRange.png](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a5411f750d2a5298dbc_gsdatarange.png)
- Select Add A Range
![GSAddRange.png](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a5315d8b76710ada8bf_gsaddrange.png)
- Enter a Name for the Range
- Select the Header fields to define the range
![GSDefineRange.png](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a53d7fd92686d19a091_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](https://cdn.prod.website-files.com/5e209fd06e0215c001008c06/5fb42a532489d63d2612bbd4_sheetcolconfig-1.png)