Save data to a Google Sheet
Your agent records what callers say in a Google Sheet of yours: contacts, booking requests, orders or the result of each call. It also looks up the caller's row, to answer with the data you keep there.
You connect your organization's Google account once. Then, for each agent, you choose the sheet and what the agent does in it.
What you need
- A Google account.
- A sheet of yours, or none: the console creates one from a template. In your own sheet, the first row must have a name in each column, with no repeated names.
- Permission to manage integrations in your organization.
Connect the Google account
- In the console, open «Integrations». In the «Google Sheets» section, select «Connect Google Sheets».
- Google's screen opens. Choose the account and allow access.
- You come back to «Integrations» and see the message «Google Sheets connected».
Choose the agent's sheet
- Open «Agents», choose the agent and go to the «Tools» tab. Select «Set up Google Sheets», or «Add tool» and then «Google Sheets». If the agent already uses a sheet, select «Configure» next to Google Sheets.
- «Configure Google Sheets» opens, in 3 steps: «Google account», «Sheet» and «What the agent does». In the first, check the account. If you have not connected it yet, select «Connect Google account».
- Under «Sheet», select one of the templates in «Create a new sheet». The sheet is created in your Google Drive, with its columns. Or, under «Use a sheet I already have», select «Choose spreadsheets» and pick it in Google's window.
- For your own sheet, also choose the «Page inside the sheet (tab)».
The templates
- «Contacts»: columns Phone, Name, Email, Notes and Last contact. The agent finds the caller by their number, saves new contacts (without repeating numbers) and updates existing ones.
- «Booking requests»: columns Phone, Name, Service, Preferred day, Preferred time, Notes, Requested on and Status. The agent records each request with a name and a service. The Status column is for your team: the agent leaves it alone.
- «Call results»: columns Date and time, Phone, Name, Reason, Summary and Next step. At the end of each call, the agent writes one row with the result.
What the agent can do
The agent works in the sheet through actions. With a template or your own sheet, the console suggests actions from the columns. There are four kinds:
- «Lookup»: during the call, the agent reads the chosen columns. In columns with personal data, it only reads the row with the number of the person calling.
- «Append a row»: during the call, it adds a row and fills the chosen columns with what the caller says.
- «Update fields»: during the call, it changes the chosen columns in the row with the number of the person calling. If that number has several rows, the agent sums up each one, asks which it is and changes only that one.
- «Final result»: when the call ends, it adds a row and writes in each column what the column's name asks for, for example «Summary».
Review and save
- Under «What the agent does», turn each suggested action on or off. Actions turned off are not saved.
- To choose other columns, open «Customize». For each column you choose the type and the privacy: «Public», «Personal (name, contact)» or «Sensitive (never use)».
- Check that «Enable Google Sheets for this agent» is ticked.
- Select «Save changes». Until then, nothing changes on the agent.
With the Builder
You can also ask the Builder to do this. It shows you cards, and you decide on each one:
- «Connect the Google account», which opens Google's screen so you can authorize.
- «Create a sheet and link it to this agent», with the columns and actions for you to review first.
- «Connect Google Sheets to this agent», for a sheet you have already chosen. Once you apply it, the agent uses the sheet on real calls.
What happens on the call
- Before adding or changing a row, the agent says what it will write and waits for the answer. It writes only after the caller confirms. Without confirmation, the sheet does not change.
- The caller's number comes from the call, never from a number the person says. Atendia writes the number and the date, and the agent does not ask for them.
- The agent asks for columns that are not required at most once. If the person does not want to give them, it writes the row without them.
- The «Final result» is written on its own, after the call ends. Only on real calls: the console's voice and text tests do not write to the sheet.
See the result
In «Call logs», open the call. The «Integration results» section shows the state of each Google Sheets operation, without the values written. The values stay in your sheet.
Good to know
- Atendia only sees the sheets you create or choose in the console, not the rest of your Google Drive.
- An agent can have at most 10 actions, and only one «Final result».
- The agent never reads or writes «Sensitive (never use)» columns. In the others, it only touches the columns you chose for each action.
- Values in the sheet are treated as data, never as instructions for the agent.
- If you change the sheet's columns, choose the sheet and the tab again before saving.
- If you disconnect Google Sheets in «Integrations», the agents lose access to the sheet.
What you pay Atendia is on the prices page: Atendia prices
The result of every call: summary, Analysis and a notice to your program