Summary
This guide explains how to connect your Google Sheets account to Astra. Once connected, Astra can interact with your spreadsheets to perform actions such as adding rows, updating records, or retrieving data as part of automated workflows.
Instructions
Follow these steps to connect your Google Sheets account to Astra:
Step 1: Open a Google Sheets action
Log into your Astra account.
Go to the Action Library.
Select a Google Sheets action template (for example, Add row).
Start the flow that requires a Google account.
This will trigger the connection process if your Google account is not yet connected.
Note:
If you have already connected one or more Google accounts, the connection pop-up may not appear.
In that case, open the action Configuration section and click Add account to connect another Google account.
Step 2: Start the connection
Click Connect Google Sheets.
A Google authentication window will open.
This will start the secure OAuth connection process.
Step 3: Sign in and grant access
Select the Google account that contains the spreadsheets you want Astra to access.
Sign in if you are not already logged in.
Review the requested permissions.
Click Allow to grant access.
This step authorizes Astra to interact with your Google Sheets through Composio.
Step 4: Complete the connection
After authorization is successful, you will see a confirmation page.
Close the page to continue.
Step 5: Verify the connection
Return to Astra.
Open the action Configuration screen.
Confirm that your connected Google account appears in the account list.
Once connected, Astra can access the spreadsheets linked to that account when configuring actions.
What to do next
After connecting your account, you can:
Select your Google account when configuring Google Sheets actions.
Choose a spreadsheet and worksheet for the action.
Automate tasks such as adding rows, updating data, or retrieving spreadsheet information.
Your Google Sheets integration is now ready to use in Astra workflows.