Connect Google Sheets to SmartChat
Connect Google Sheets in the AI Chat. Then SmartChat sends the right WhatsApp for every new row in your sheet.
Every row becomes a message.
Whether it's a match schedule, guest list or repair list: as soon as something changes in your sheet, an automation can reach the right contact in WhatsApp.
You enter the home game, the parents read it in WhatsApp.
Everyone checked off at the entrance gets a thank-you the next day.
When the status in the list changes, the customer finds out right away.
From the new row to the message.
A tool like Make, Zapier or n8n reports the row to the secret webhook address of your automation. SmartChat takes care of the rest.
You add to the sheet
You or your team add a new row, with name, phone number and whatever the contact should know.
Google SheetsThe tool reports it
Make, Zapier or n8n send the row's values to the webhook address. Some tools only send IDs, then they fetch the values first.
webhookThe automation starts
SmartChat finds the contact by phone number and checks if your filter matches, for example status equals done.
FiltersThe WhatsApp goes out
The contact reads an approved template where SmartChat fills in the values from the row.
WhatsApp
What SmartChat can do in your sheet
The Google Sheets docs list these actions. SmartChat AI picks the right one for the goal you describe in the AI Chat.
- Add every new contact from my landing page with name and number to the sheet Mitglieder.
Add row
Every new contact ends up at the bottom of the list.
- Find the row with the contact's phone number in the sheet Reparaturen and set the status to done.
Find row
SmartChat searches for the first row where a cell matches.
- Add up the sign-ups in the column Teilnahme every week.
Calculate values
Sum, average or count of a column.
- Create a new sheet called Gästeliste for the summer party.
Create new spreadsheet
A fresh list for every season or campaign.
- Export the sheet Spielplan as a PDF every Friday.
Export as PDF
A sheet or a range becomes a PDF file.
- Sort the list by date as soon as a row is added.
Sort list
By one or more columns.
How to connect Google Sheets
You don't need any tech skills for this. You write it in the AI Chat and allow access at Google.
You write it in the AI Chat
Write in the AI Chatthat you want to connect Google Sheets. SmartChat AI shows you the card with the button.
AI ChatGoogle asks
In Google's sign-in window, you choose your account and allow access. You only enter your password there.
GoogleYour sheets are ready
SmartChat AI can now use them in your automations.
Connected
How the contact sees it in WhatsApp.
Values from your row
Date, place or status come straight from the cells and appear in the message.
With an approved template
Outside the inbox, messages only go out as a template that Meta has checked.
Replies in the inbox
If the contact replies, their message lands in the inbox.
Keeping a guest list, reminders sent automatically.
Check off guests in the sheet, an automation handles the rest the day before.
One column, one trigger
You decide which change in the sheet starts the automation.
At the right time
You set in your tool when the report reaches SmartChat.
Cancellations visible right away
Anyone who cancels writes straight in the chat, and your team sees it in the inbox.
You describe the goal, not every click.
In plain sentences, you tell SmartChat AI the goal, what should happen automatically. Before it starts, you see the whole automation.
- 1
Name the goal
Who gets which message and when?
Send every guest a WhatsApp with entry and directions the day before the event. - 2
Define sources
Which sheet should be the trigger?
Use the sheet Gästeliste and start as soon as there's a yes in the column Zusage. - 3
Check and switch on
You see trigger and message before anything runs.
Show me the automation before it starts.
Keeping lists, without and with SmartChat.
Just the sheet
- You read through the list and message everyone individually.
- Anyone who signs up late gets overlooked.
- Whether the contact received the message, you don't know.
- Keeping the list and writing messages run separately.
Sheet plus SmartChat
- A new row starts the message on its own.
- New contacts from your landing page land automatically in the list.
- Replies are collected by your inbox, not your phone.
- The sheet stays your place, you keep working as usual.
Frequently asked questions about Google Sheets and SmartChat.
How do I connect Google Sheets with SmartChat?
Write in the AI Chatthat you want to connect Google Sheets. SmartChat AI shows you a card with the button to connect. Then Google's sign-in window opens, where you choose your account and allow access.
Does SmartChat see my Google password?
No. You sign in in Google's window and only enter your password there. SmartChat doesn't get it.
Can SmartChat write new contacts into my sheet?
Yes. An automation can add a new row at the end of your sheet, for example for everyone who signs up through your landing page . You decide in the AI Chat which columns get filled.
Can SmartChat find and change a specific row?
Yes. The docs list a search for the first row where a cell matches your search term, and changing cells. That way you can, for example, update the status of a sign-up.
How does a new row in my sheet start a WhatsApp?
Every automation can have the trigger "Event from an app" and gets a secret webhook address. A tool like Make, Zapier or n8n reports the new row there. SmartChat finds the contact by phone number and sends the message.
What happens if there's no phone number in the row?
Then SmartChat can't send a WhatsApp and skips the step. So put the number in its own column so it comes in with the report.
Can the sheet do calculations, like sums or averages?
Yes. According to the docs, an action can calculate column values: sum, average, count, smallest and largest value, also with a filter. You decide what SmartChat uses the result for.
Can SmartChat create a new spreadsheet or a new sheet?
Yes. There are actions that create a new spreadsheet in your Drive and add another sheet to an existing spreadsheet.
Can SmartChat export a sheet as a PDF?
Yes. The docs list a PDF export for a sheet or a range, as well as formats like CSV and XLSX for the whole spreadsheet.
Which plan do I need for an automation with Google Sheets?
An automation with Google Sheets counts as an additional automation. Free and Starter only include the fixed automation for new contacts. Basic gives you three, one of them fixed, and Pro as many as you want.
What do I pay for messages that come from the sheet?
Sending and every automation run cost 0 credits. Plans start at €0 on Free, then €299, €499 and €999 a month, each plus VAT. Meta charges its own fees per message; the prices are here.
Why do reminders need an approved template?
When SmartChat contacts someone outside the inbox, it uses a template that Meta has checked and approved. SmartChat AI writes it for you and submits it. Replies within the open window go straight through the inbox.
What happens if someone on my list writes STOP?
They're unsubscribed right away and get no more messages, neither newsletters nor automations. Even if you don't remove them from the sheet, they stay unsubscribed.
Your list works with you. In 60 seconds your system is ready.
Enter your website, and SmartChat AI builds the landing page, confirmation and thank-you message. Then you connect Google Sheets in the AI Chat.