Summary
This guide explains how to configure the Google Sheets — Update row action in Astra. This action allows your agent to update an existing row in a selected Google Sheets worksheet (tab).
To ensure the action works correctly, the sheet must contain one non-empty header row at the top. These headers define the column structure used when updating values.
In most workflows, the agent must first locate the row to update using the Google Sheets — Search and find row action. Once the correct row is identified, the Update row action can modify the values in that row.
Before configuring this action, make sure your Google account is connected to Astra.
Instructions
Follow these steps to configure the Google Sheets — Update row action:
Step 1: Open the action template
Log into your Astra account.
Go to the Action Library.
Select Google Sheets — Update row.
Open the Configuration page.
You will configure several sections on this page.
Step 2: Configure the action intent
In the Action intent section:
Enter an Action name.
Write an Intent that explains when the agent should update a row in the spreadsheet.
Why this matters
The intent helps the agent understand when it should use this action.
Clear instructions improve how accurately the agent triggers the update.
Example use cases include updating a customer status, modifying order details, or changing lead information.
Step 3: Select the Google account
In the Google account section:
Choose the connected Google account that has permission to edit the spreadsheet.
How this works
Astra uses the selected account to access Google Sheets through secure OAuth authentication.
The account must have edit access to the spreadsheet.
Step 4: Select the spreadsheet and worksheet
In the Spreadsheet and worksheet section:
Select the Drive location.
Choose the Spreadsheet.
Select the Worksheet (tab) where the row should be updated.
Important:
Only spreadsheets located in My Drive or Shared Drives can be used with this action.
Updates will apply only to the selected worksheet.
Additional feature: Offline sync
Astra also supports Offline Sync, which allows this action to run after a conversation ends instead of during the live interaction.
How Offline Sync works
If Offline Sync is enabled on the Action intent page:
The action runs once after the conversation ends and a lead is captured in Astra.
The update does not occur during the live chat.
Conversation end conditions
Text agents: The conversation is considered finished when 10 minutes have passed since the last message.
Voice agents: The conversation ends when the call ends.
When Offline Sync is enabled:
The Search and find row action is not required in the agent workflow.
Astra processes the update automatically after the conversation.
What happens when the action runs
When the action is triggered:
Astra identifies the correct row in the selected worksheet.
The agent generates updated values based on the workflow context.
The specified fields in that row are updated.
This allows your workflows to automatically maintain accurate data in Google Sheets, such as updating customer records, lead information, or operational tracking data.