Connect Gmail to Google Sheets
Ideas
What you can do with Gmail and Google Sheets
Copy a table from a web page into a sheet every morning
Each morning the listings on a page you choose are added to your Google Sheet, and you get the same rows by email as a CSV.
See how it worksLog PDF invoices from Gmail in a spreadsheet
Every invoice that arrives by email is added as a row in your Invoices sheet with supplier, date, number and total.
See how it worksDraft a LinkedIn post from your content sheet every weekday
Each weekday you get an email with a ready-to-edit LinkedIn post about the next idea in your Content sheet.
See how it worksSend personal emails to a lead sheet and follow up on no-replies
Each weekday the next batch of leads in your sheet gets your email from Gmail, people who do not reply get a follow-up, and the sheet tracks every status.
See how it worksMonitor websites from a sheet with email alerts
You get an email when a site in your sheet goes down, and every outage is logged in the same sheet.
See how it worksFill your timesheet from the emails you sent today
Each evening your timesheet gets rows for the clients and projects you emailed about, ready to check before invoicing.
See how it worksReply to chosen senders with AI and log every exchange
When someone on your list emails you, they get a prompt reply written by AI, and each email and reply is logged in a Google Sheet.
See how it worksScore new leads in a sheet and email the best ones
Each new lead in your sheet gets a score and a reason, and you get an email with a suggested first message for any strong one.
See how it worksGet warned before an SSL certificate expires
Your sheet of domains shows how many days each certificate has left, and you get an email when any drops under 14 days.
See how it worksGet a weekly email summary of new form responses
Every Friday you get one email that sums up the week's new feedback in your responses sheet, question by question.
See how it works Your own logicAny other automation you can describe in words
Your own rules, schedule and AI steps with Gmail and Google Sheets, plus any other app. Describe it and your assistant builds it.
See how to build your ownMore ideas
Add event sign-ups to a sheet and send a confirmation
Each registration lands in your Attendees sheet and the person gets a confirmation email straight away.
See how it worksScreen job applications with AI and log them in a sheet
Every application is rated against your job description, logged in a sheet, and both HR and the candidate get an email.
See how it worksLog TradingView alert emails to a Google Sheet
Every TradingView alert email becomes a row in your Signals sheet with the ticker, buy or sell signal and price.
See how it worksGet an email when a product drops below your target price
The products in your sheet are checked every 6 hours, each price is logged, and you get an email when one falls below your target.
See how it worksSend overdue invoice reminders from a sheet
Clients with unpaid invoices get a polite reminder, then firmer ones after 14 and 30 days, and the sheet records when each was sent.
See how it worksBuild your own
Build any Gmail and Google Sheets automation you can describe
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 weekday morning, email each person in my Renewals sheet whose Renewal Date is within 30 days and who has not been emailed yet, then write today's date in the Emailed column.
Check my Gmail every 15 minutes for order emails, use AI to pull the order number, items and total, and add one row per order to my Orders sheet, skipping orders already in the sheet.
Use cases
Why people connect Gmail and Google Sheets
How the two apps work together
- ClickRuntime checks Gmail for messages matching a label or search every few minutes and writes details into sheet rows.
- On a schedule, it can read rows from the sheet and send emails from your Gmail address, marking each row as sent.
- Replies can be checked the same way and logged back to the sheet next to the original row.
Founder logs invoices from email
Invoices and receipts arriving in Gmail can be added as rows with Vendor, Date and Amount. The sheet becomes a running expense log for the accountant.
Sales rep sends personal follow-ups from a list
A sheet with Name, Email and Last Contact columns can drive individual follow-up emails from Gmail. The sheet records when each one was sent.
Recruiter tracks applications by email
Job applications arriving by email can be added to a sheet with the candidate name, role and attachment link. Hiring managers review in one place.
Ecommerce owner records orders from notifications
Order notification emails from a store or marketplace can be parsed into rows. The owner gets a simple sales log without exports.
More apps
Gmail, Google Sheets and other apps in one automation
Email leads to a sheet with Slack alert
When a Gmail message arrives from our contact form, add the name, email and message to my Leads sheet and post it to #sales in Slack.
Save attachments to Drive and log them
For each email labeled Invoices, save the PDF to my Drive Invoices folder and add a row to my Expenses sheet with the link and amount.
Sheet contacts to HubSpot after a reply
When someone on my Outreach sheet replies in Gmail, create them as a HubSpot contact and mark the row as Replied.
Fill a Doc for each new row and email it
When a new row is added to my Contracts sheet, copy my Docs template, fill in the name, amount and start date, and email a link to the address in the row.
Save invoice attachments and log them
Every 15 minutes, save PDF attachments from emails labeled Invoices to my Drive folder Invoices/<month>, and add the sender, amount, due date and file link to my Invoices sheet.
Fill the weekly deck and email it
Every Monday at 8 am, copy my Weekly review deck, replace the placeholders with this week's numbers from my Metrics sheet, and email the link to my team.
Lead emails to Airtable and a reporting sheet
When an email arrives at leads@, extract the name, company and request, add a record to my Airtable Leads table and a row to my Pipeline sheet.
Daily pipeline sheet with a summary email
Every weekday at 8 am, copy my open Pipedrive deals with stage, value and owner to my Pipeline sheet and email me which deals moved stage yesterday.
Setup
Connect Gmail and Google Sheets once
Gmail
- At console.cloud.google.com, create a project and enable the Gmail API under APIs & Services → Library.
- Set up the OAuth consent screen. On Google Workspace choose Internal. On a personal Gmail account choose External, then under Audience click Publish app so it is In production, not Testing.
- Under Data Access, add the scopes you need, such as
https://www.googleapis.com/auth/gmail.modify, orgmail.sendif you only want to send. - Under Clients, create an OAuth client of type Web application with the redirect URI
https://clickruntime.com/oauth/callback. - In the ClickRuntime dashboard, open Connections, choose Gmail and enter the client ID and secret. On a personal account Google shows an unverified-app screen: click Advanced, then go to your app.
Google Sheets
Spreadsheets
- In the ClickRuntime dashboard, open Connections and choose Google Sheets.
- Sign in with your Google account and allow access.
- Pick the spreadsheets the automation may use. It can't see any other file in your Drive.
FAQ
Questions about connecting Gmail and Google Sheets
Do I need a particular sheet layout?
Which address do the emails come from?
How does it avoid emailing the same person twice?
Is there a sending limit?
Is it two-way between Gmail and Google Sheets?
Can it pick out amounts or names from the email body?
Will it log emails that were already in my inbox?
Related pages
Keep exploring
Tell your assistant what Gmail and Google Sheets should do together
Free plan. No credit card.