Summary
This guide explains how to configure the Google Sheets — Add row action in Astra. This action allows your agent to automatically append a new row to a selected Google Sheets worksheet (tab).
When a row is added, Astra aligns the values with the column headers defined in the first row of the worksheet. To ensure the action works correctly, the sheet must contain one non-empty header row at the top that defines the column names.
Before configuring this action, make sure your Google account is connected to Astra.
Instructions
Follow these steps to configure the Google Sheets — Add row action in Astra:
Step 1: Open the action template
Log into your Astra account.
Go to the Action Library.
Select Google Sheets — Add row.
Open the Configuration screen.
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 describing when the agent should add a row to the sheet.
Why this matters
The intent helps the agent understand when to trigger the action.
Clear instructions improve the accuracy of automated workflows.
For example, the agent may add a row when a new lead is captured or when a task is completed.
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 rows should be added.
Important:
Only spreadsheets located in My Drive or Shared Drives can be used with this action.
New rows will always be appended to the selected worksheet.
What happens when the action runs
When the action is triggered:
Astra generates the row data based on the agent’s instructions and context.
The values are matched with the header columns in the sheet.
A new row is appended to the selected worksheet.
This allows your workflows to automatically log information in Google Sheets, such as new leads, activity logs, support requests, or workflow events.