Google Sheets Block

What it does: Read and write data to Google Sheets, turning your spreadsheets into a simple database for your workflows.

📋

In simple terms: Google Sheets becomes your dynamic data storage. Pull customer lists, save form responses, update inventory counts, or track anything your workflow needs - all in familiar spreadsheet format that your team can easily view and edit.

When to Use This

Use Google Sheets when you need:

✅ Simple data storage your team can access
✅ Read and write to existing spreadsheets
✅ Track information over time
✅ Share data easily with non-technical users
✅ Quick database without complex setup

Example: Save lead information from chat conversations to a Google Sheet, where your sales team can see all new leads and their details.

Key Features

Read Operations: Pull data from any spreadsheet
Write Operations: Add new rows or update existing data
Row Targeting: Work with specific rows using filters
Real-Time Access: Changes appear immediately in your sheet
Familiar Interface: Everyone on your team can view and edit

Understanding Sheet Structure

Term	What It Means
Spreadsheet	The entire Google Sheets file
Sheet/Tab	A single page within the spreadsheet
Row	A horizontal line of data (usually one record)
Column	A vertical category (name, email, date, etc.)
Cell	A single data point where row and column meet
Range	A group of cells (like A1:C10)

Setup Guide

Step 1: Connect Your Google Account

Add your Google credentials to access Sheets
Grant permission to read and write spreadsheets
The connection will give access to your Google Drive spreadsheets

Step 2: Select Your Spreadsheet

Choose which spreadsheet to work with:

Browse your Google Drive
Or paste the spreadsheet URL directly
Select the specific sheet/tab within the file

Step 3: Choose Your Operation

Operation	What It Does
Get Values	Read data from specified range
Append Row	Add a new row at the bottom
Update Row	Modify an existing row
Insert Row	Add a row at a specific position
Delete Row	Remove a row from the sheet
Clear Range	Remove data from specified cells

Step 4: Configure the Operation

For Reading Data:

Specify the range to read (e.g., "A1:D100" or "A:D")
Optionally include headers

For Writing Data:

Specify which columns to fill
Map your workflow variables to sheet columns

Common Use Cases

Lead Collection

Whenever your workflow captures a new lead, automatically add their name, email, phone, and inquiry to a "Leads" sheet for your sales team.

Order Tracking

Log every order with customer details, products, and status. Update the status column as orders progress through fulfillment.

Inventory Management

Track stock levels in a sheet. When products are sold or restocked, automatically update the quantities.

Data Lookup

Pull customer information from a sheet based on email address or ID to personalize conversations.

Report Generation

Append daily, weekly, or transaction data to a sheet that automatically generates charts and summaries.

Form Responses

Store responses from chat conversations or workflows in an organized sheet for later analysis.

Operations Explained

Get Values (Read)

Pull data from your spreadsheet.

What you specify:

Range to read (e.g., "A2:E100")
Whether first row contains headers

What you get:

All data from that range
Organized by rows and columns

Append Row (Add)

Add a new row at the bottom of your data.

What you provide:

Values for each column in order
Or mapped fields to columns

Update Row (Modify)

Change data in an existing row.

What you provide:

How to find the row (row number or filter)
New values for the columns to update

Insert Row

Add a row at a specific position (pushes other rows down).

What you provide:

Row number where to insert
Values for the new row

Delete Row

Remove a row entirely from the sheet.

What you provide:

Row number to delete
Or filter to find the row

What You Get Back

After a Google Sheets operation:

For Reads: All the data from your specified range
For Writes: Confirmation of successful write
Row Count: Number of rows affected
Updated Range: The exact cells that were modified

Tips for Success

Use headers - First row as column names makes data clearer
Keep data consistent - Same format in each column (all dates formatted alike)
Plan your structure - Think about what data you need before creating
Use named ranges - Easier to reference specific data sections
Validate before writing - Make sure data is complete before saving

Troubleshooting

Problem	Likely Cause	Solution
Permission denied	Not authorized	Reconnect Google account with proper permissions
Sheet not found	Wrong name or deleted	Verify spreadsheet exists and name is exact
Data not appearing	Wrong range specified	Double-check range includes your data
Overwriting data	Using wrong operation	Use Append for new rows, Update for existing
Empty cells	Missing data	Ensure all variables have values

Best Practices

Keep sheets organized - One purpose per sheet, clear column headers
Use separate tabs - Different data types in different sheets within the file
Back up important data - Google Sheets has version history, but extra backups help
Set up data validation - In Google Sheets, restrict what can be entered in columns
Document your sheets - Add a "About" tab explaining what data is tracked

Amazon Bedrock MySQL