- Integrations
- Google Sheets
Google Sheets integration: answers added to your spreadsheet as rows
Agenola's Google Sheets integration adds the visitor's answers to your spreadsheet as a new row, searches a column and reads the matching row, and writes, formats and summarizes ranges. You can keep applications, requests or a price list in a spreadsheet without setting up a separate system. You connect it in one click with your Google account.
How it works
The two most used steps are "Append row" and "Find row". "Append row" writes the visitor's answers as a new row at the end of the table on the sheet and leaves existing rows alone. "Find row" searches a column for a value and returns the matching rows, and the agent answers with what's in that row.
You pick the spreadsheet and the sheet from a list on the step. The first row of the sheet is treated as the header.
Google Sheets, Google Drive, Docs and Slides share one connection: connect one and all four are connected; remove it from any of them and the steps of all four stop together.
- Values are written exactly as they are; text the visitor types that starts with = doesn't become a formula. Formulas are added only by a "Set formula" step you write in the flow.
- Permanent actions such as deleting a sheet don't run until the confirmation box on the step is ticked.
- The "Convert Excel file" step turns an Excel file in Drive into a Google Sheets copy; the Excel file stays where it is.
What it does
This list is generated from the same source as the Google Sheets page in the dashboard: if it isn't listed here, we don't do it with Google Sheets. Flow steps live in the flow editor under Add step → Integrations → Google Sheets.
SpreadsheetAction · Flow step4
Get spreadsheet
Reads the spreadsheet's name, link and sheets (tabs).
Create spreadsheet
Creates a new spreadsheet in Drive.
Find and replace
Finds a text in the spreadsheet or the selected sheet and replaces it; returns the number of changed cells.
Convert Excel file
Creates a Google Sheets copy of an Excel file in Drive; the Excel file stays in place.
RangeAction · Flow step6
Read range
Returns the rows in the range as a list; the first cell's value can also be saved to a variable.
Write range
Overwrites the cells in the range. Values are written as they are; text starting with = does not become a formula.
Clear range
Deletes the values in the range; formatting stays.
Sort range
Sorts the rows in the range by a column.
Format range
Sets bold, italic, colors, number format and alignment; properties left empty do not change.
Merge cells
Merges the cells in the range or removes the merge.
RowAction · Flow step2
Append row
Adds rows after the table on the sheet; existing rows are not touched.
Find row
Looks up a value in a column and returns the matching rows. The sheet's first row is treated as the header.
CellAction · Flow step1
Set formula
Writes a formula to a cell. Put {variable} values inside double quotes in the formula.
SheetAction · Flow step5
Add sheet
Adds a new sheet (tab) to the spreadsheet.
Update sheet
Changes the sheet's name or tab color.
Duplicate sheet
Creates a copy of the sheet with its contents.
Delete sheet
Permanently deletes the sheet and everything in it.
Freeze rows and columns
Keeps the first rows or columns in place while scrolling; 0 unfreezes.
Rows and columnsAction · Flow step3
Insert rows or columns
Adds empty rows or columns before the given row or column.
Delete rows or columns
Deletes rows or columns together with their contents.
Resize rows or columns
Sets the row height or column width; fits the content when no size is given.
FilterAction · Flow step2
Turn on filter
Adds filter buttons to the range (or the whole sheet when empty).
Remove filter
Removes the filter on the sheet; the data does not change.
ChartAction · Flow step1
Create chart
Draws a chart from the range: the first column is the categories, the next columns are the series, the first row is the header.
Pivot tableAction · Flow step1
Create pivot table
Groups the range by one column and summarizes another; writes to a new sheet when no target is given.
Data validationAction · Flow step1
Set dropdown list
Makes the cells in the range accept only the given options.
Conditional formattingAction · Flow step1
Add conditional formatting
Colors the cells that meet the condition.
Protected rangeAction · Flow step1
Protect range
Protects the range (or the whole sheet when empty) from editing, or warns the editor.
Named rangeAction · Flow step1
Name range
Gives the range a name that can be used in formulas.
Example conversations
Visitor: I'd like to apply for the sales associate role.
Agent: Happy to help. Could you share your name, phone number and how many years of experience you have?
Visitor: Daniel Reed, +1 415 555 0132, 4 years
Agent: Thank you, I've received your application. The team will review it and get in touch.
Behind the scenes: The "Append row" step writes a new row at the end of the "Applications" table: date, Daniel Reed, phone number, 4 years and the source agent.
Visitor: How much is cleaning for a 1,300 sq ft office?
Agent: Office cleaning up to 1,500 sq ft is $240 per visit, or $210 per visit on a weekly plan.
Behind the scenes: The "Find row" step searches the service column of the "Prices" sheet for "Office cleaning"; the agent answers with the size and price columns of the matching rows.
Visitor: What's the status of order 2041?
Agent: Order 2041 is being prepared; the estimated delivery date is November 14.
Behind the scenes: The "Find row" step searches the order number column of the "Orders" sheet for 2041 and reads the status and delivery date columns. A business without store software can track orders this way.
Setup
- 1In Agenola, go to Integrations → Google Sheets and press "Connect Google Sheets"; choose your Google account and tick every box on the consent screen. Drive, Docs and Slides are connected with it.
- 2In the flow editor, add the "Append row" or "Find row" step under Add step → Integrations → Google Sheets.
- 3On the step, pick the spreadsheet and the sheet from the list, and choose which of the visitor's answers go into each column.
Detailed setup: How do I use Gmail, Google Calendar and Drive?
Permissions and where your data goes
- Sent to Google Sheets: the values you set on the steps, usually the visitor's answers and the date of the conversation.
- Read from Google Sheets: only when a step asks, the range that step reads or the rows it finds; the list of spreadsheets in your Drive for the spreadsheet and sheet pickers.
- Permission requested: Google Drive full access, with which Sheets, Docs and Slides are edited; your email address and Google ID to recognize the account.
- Connection details are stored encrypted on the server. Only the workspace owner and admins can connect or remove it; when you remove it, your spreadsheets stay in Drive as they are.
Related integrations
See all integrations
Google Calendar
Shows free slots and books the appointment, with a Meet link, at the chosen time.
Calendly
The agent shows your free times and books the visitor into your Calendly.
Google Drive
Your agents search, read, copy and share files.
Google Docs
Your agents create documents and fill templates with the visitor's answers.
Google Slides
Your agents create presentations and fill slides with answers.
Gmail
Your agents send, reply to and draft email from your account.
Frequently asked questions
Does a formula typed by a visitor run in the sheet?
No. Values are written as they are, so an answer starting with = goes into the cell as text. Only a "Set formula" step you write in the flow adds a formula.
Do I need to connect Google Drive separately?
No. Sheets, Drive, Docs and Slides share one connection; connect one and all four are connected.
Are existing rows overwritten?
"Append row" always adds a new row at the end of the table and leaves existing rows alone. To update a cell, you use the "Write range" step.
Can I work with my Excel file?
If the Excel file is in Drive, the "Convert Excel file" step creates a Google Sheets copy of it; the steps work with that copy and the Excel file stays where it is.