Guides

Using Google Sheets

Guidelines to using Google Sheets with Stubber

Overview

Stubber can interact with Google Sheets to read and write data. Before using Google Sheets with Stubber, you'll need to set up authentication using one of two methods:

1. Share individual sheets with the Stubber service account
2. Create a Stubber credential with your Google account

Authentication Methods

1. Using the Stubber Service Account

The simplest method is to share your Google Sheets with Stubber's service account: share-with@stubber-sheets.iam.gserviceaccount.com

This approach:

• Requires sharing each sheet individually with the service account
• Gives Stubber read and write access only to the specific sheets you share
• Requires no additional setup in Stubber Manage

2. Using a Stubber Credential

Alternatively, you can create a credential in Stubber Manage using your Google account.

This approach:

• Gives Stubber access to all Google Sheets that your Google account can access
• Requires setting up a credential once in Stubber Manage
• Requires using the orgcredentialuuid parameter in Google Sheets tasks

Available Tasks

Stubber provides three tasks for interacting with Google Sheets:

For writing data:

• Log to sheet
• Update sheet rows

For reading data:

• Read sheet rows

Best Practices

When working with Google Sheets in Stubber, we recommend:

1. Using the update_sheet_rows task for most use cases, as it provides the most flexibility for both inserting and updating data

2. Implementing a unique identifier system:

   • Use the first column to store a unique identifier for each row
   • This could be data from your stub or a Stubref
   • Use the filter_column and filter_value parameters to target specific rows

3. Understanding how updates work:

   • If a row with the specified unique identifier exists, it will be updated
   • If no matching row is found, a new row will be inserted
   • This ensures data consistency and prevents duplicate entries