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