Skip to content
ClickRuntime

Automate Google Sheets

Use a sheet as the list an automation works through: score new leads, fill empty columns from company websites, clean and dedupe rows, and log form entries as they come in. Sheets also drive alerts and reports, from due dates and price drops to a daily KPI email. Describe what you want to your AI assistant, check what it will do, and it keeps running with your laptop closed.

Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Try asking

Create a ClickRuntime automation: every hour, for rows in my Companies sheet with an empty Industry column, read the company's website and fill in industry, B2B or B2C, and a one-line summary.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Ideas

What you can automate in Google Sheets

Rows that fill themselves in, lists that stay clean, alerts when a value or date needs attention, and reports written from your numbers. These are ready-made starting points. Anything else you can describe works too.
HourlyAI

Fill in company details from their websites

Each company in your sheet gets its industry, B2B or B2C, and a one-line summary from its own website.

See how it works
Every 15 minutesAI

Score new leads in your sheet

New leads get a score from 1 to 10 and a reason, so you know who to call first.

See how it works
DailyAI

Draft posts from your content sheet

Each morning the next idea in your sheet becomes a draft, saved back in the row.

See how it works
HourlyAI

Draft personal outreach emails from a list

Every contact in your sheet gets a short personalised email written into the row, ready for you to send.

See how it works
Daily

Keep your sheet free of duplicates and bad data

Duplicate rows are removed, names and phone numbers are tidied, and invalid emails are flagged.

See how it works
The moment it happens

Add form entries to a sheet as they arrive

Anything sent to your link, from a form, a website or another tool, appears as a new row.

See how it works
Every 30 minutesAI

Tag customer feedback by sentiment and topic

Every feedback row gets a sentiment and topic, and the negative ones are flagged to you.

See how it works
On a scheduleAI

Label a list of keywords by intent

Every keyword or text row gets an intent and a topic label filled in.

See how it works
The moment it happensAI

Log expenses and catch budget overruns

Your expenses land in a sheet, and you're warned when a category goes over its monthly budget.

See how it works
Every 6 hoursAI

Track prices from a watch list

You're told when a product in your sheet drops below your target price.

See how it works
On a schedule

Monitor your sites and SSL certificates

You're warned when a site in your list is down or its certificate expires within 14 days.

See how it works
On a scheduleAI

Log daily closing prices for your tickers

Each weekday the closing prices for your watch list are logged, with a short note on the big movers.

See how it works
On a scheduleAI

Get a written monthly report from your numbers

Each month you get a written analysis of your sheet's figures, compared with earlier periods.

See how it works
Every 5–15 minutes

Get notified about new rows

Whenever a row is added to your sheet, you see it in Slack within minutes.

See how it works
Daily

Get alerts for upcoming dates in a sheet

You're emailed when a date in your sheet is coming up or a value crosses a limit.

See how it works
Daily

Get a daily list of tasks due

Each morning you get the rows in your tracker that are due today or overdue.

See how it works
Daily

Back up a sheet tab every night

Each night a dated copy of your tab is kept, with the last 14 days saved.

See how it works
Every 15 minutes

Get told when a status changes in a shared sheet

When someone edits a status or owner, you see the old and new value.

See how it works
Daily

Get yesterday's totals every morning

Each morning you get yesterday's totals from your sheet, compared with the day before.

See how it works
Every 10 minutesAI

Fill a category column for new rows

New rows get a category filled in from the text in another column.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what Google Sheets should do in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Every hour, go through my Leads sheet, use AI to fill the empty Industry and Company size columns from the website column, and mark rows with no website as Needs review.

Every day at 9, check the Due date column in my Invoices sheet and send a Gmail reminder to each client whose invoice is more than 7 days overdue.

When a new row is added to my Content Ideas sheet, use AI to write a draft, save it as a Google Doc in my Drafts folder in Google Drive, and post the link in #marketing on Slack.

Works with

Google Sheets with the apps you already use

A sheet is often the shared list behind a process. Connect it to email, chat and files so rows turn into messages and new information turns into rows.

Google Sheets works with hundreds of other apps

Name any of them when you ask your assistant, and your automation connects them. Over 248 apps are ready to go, and anything with an API works too.

  • Airtable
  • Notion
  • HubSpot
  • Typeform
  • Google Forms
  • Stripe
  • Shopify
  • Microsoft Excel
  • Jotform
  • Tally
  • Salesforce
  • Pipedrive
  • Trello
  • Asana
  • OpenAI
  • Discord
  • QuickBooks
  • Mailchimp

Beyond chat

Have Google Sheets work when you're not in the chat

Connecting Google Sheets to ChatGPT or Claude lets you ask about it while you chat. ClickRuntime handles the part that should happen on its own: checks on a schedule and actions on each new event, set up from the same chat and running after you close it.

Setup

Connect Google Sheets

Connect your Google Sheets account with a Google sign-in, then pick the spreadsheets you want to give access to. Automations can only open the files you picked, and you can add more files or disconnect at any time.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

Good to know

Google Sheets limits that affect automations

  • The Sheets API allows about 300 read requests per minute per project and 60 per minute per user by default, so automations read ranges in batches rather than cell by cell.
  • Sheets has no webhook for new or edited rows, so row alerts check the sheet on a schedule, every 5 to 15 minutes.
  • Change alerts compare against a saved snapshot, so keep those sheets to a few thousand rows.

FAQ

Questions about automating Google Sheets

What can ClickRuntime see in my Google Sheets?
Only the spreadsheets you picked when connecting. In those, it can read, add and update rows, add tabs and change formatting. It can't open other files in your Drive.
Will it notice new rows straight away?
Within minutes. Sheets doesn't send webhooks, so automations check the sheet every 5 to 15 minutes. Data sent to a trigger link is added as a row at once.
Can it send emails to the contacts in my sheet?
Not on its own. Outreach automations write a personalised draft into a column for you. To send them, connect an email app such as Gmail.
Do I need AI for spreadsheet automations?
No for logging, cleaning, alerts, backups and KPI totals. Scoring, tagging, enrichment and written reports use the AI that comes with every ClickRuntime plan, so you don't need your own AI key.
Can it see all the files in my Google Drive?
No. When you connect, you pick the spreadsheets it may use, and it can only open those. To add another sheet later, pick it again from Connections in the ClickRuntime dashboard.
Is this a Google Sheets connector for ChatGPT or Claude?
Not for chatting with Google Sheets data. A chat connector lets your assistant read and change Google Sheets while you're in the conversation. ClickRuntime is for the work that should happen without you: you set up an automation from the chat once, and it keeps running on a schedule or on each Google Sheets event.

Related pages

Keep exploring

Tell your assistant what Google Sheets should do

Free plan. No credit card.

Add to ChatGPTAdd to Claude