Guides
Using Google Sheets
Guidelines to using Google Sheets with Stubber
Overview
To start using Google Sheets with Stubber, you need to create a credential in Stubber Manage. This credential is used to authenticate Stubber with Google Sheets.
Once you have created a credential, you can use it in tasks that interact with Google Sheets.
There are 2 tasks the enable adding / manipulating data in Google Sheets:
There is 1 task that enables reading data from Google Sheets:
Recommended Usage
After creating a credential, we recommend using the update_sheet_rows task for advanced use cases. This task is more flexible and can be used to update as well as insert rows in a sheet.
The best way to insert data into a sheet is to decide on a unique identifier for each row.
This unique identifier could be some data within the stub or else you can use the Stubref.
You can then use the update_sheet_rows task to insert the data.
Use the first column in the sheet to store the unique identifier.
You can use the filter_column and filter_value parameters to set the unique identifier and all the other column values in the row.
If the row does not exist, it will be inserted. If the row exists, it will be updated with the data supplied.