Skip to content
ClickRuntime

Connect Gmail, Google Drive and Google Sheets

Attachments pile up in Gmail, the files belong in Google Drive and the details belong in Google Sheets. One automation can save each attachment to the right folder and log it in a sheet at the same time.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Workflows

What Gmail, Google Drive and Google Sheets can do together

Each of these is one automation that uses all three apps. Copy a prompt into your assistant and change the details to fit.

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.

File CVs by role and track candidates

When an email arrives at jobs@ with a CV attached, save the file to the Drive folder for the role in the subject line and add the candidate's name, email and role to my Candidates sheet.

Weekly sheet snapshot emailed as a link

Every Friday at 5 pm, save a PDF of my Sales sheet to Drive and email the link to my team with this week's totals in the message.

New files in a shared folder logged and announced

When a new file appears in my Drive folder Client uploads, add its name, uploader and link to my Uploads sheet and email me a short note.

Use cases

Why people use Gmail, Google Drive and Google Sheets together

  • Receipts and invoices filed and logged

    Finance and freelancers get invoices as PDF attachments. The automation saves each one to a Drive folder by month and adds vendor, amount and file link to a sheet.

  • Applications and CVs in one place

    Recruiters receive CVs by email. The automation stores each file in a Drive folder per role and lists the candidate in a tracking sheet.

  • Reports shared on a schedule

    Teams export data to a sheet. The automation saves a PDF copy to Drive every week and emails the link to the people who need it.

Ready-made ideas

Start from two of the three apps

These automations use two of the apps. Ask your assistant to add the third as an extra step.

Gmail + Google Drive

Every 15 minutesAI

Save invoice PDFs from Gmail to Drive, named by supplier and amount

Invoice and receipt PDFs in your inbox are saved to Drive as date_supplier_amount files, and the email is labelled as filed.

See how it works
Every 15 minutesAI

Transcribe emailed audio and save summaries to Drive

Voice notes and recordings sent to your inbox become a transcript and summary in Drive, with the summary emailed to you.

See how it works
Every 10 minutes

Save client email attachments into Drive, one folder per company

Attachments from client emails are filed in Drive automatically, each in a folder named after the sender's company.

See how it works

Gmail + Google Sheets

Daily

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 works
Every 10 minutesAI

Log 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 works
Daily or weeklyAI

Draft 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 works

Google Drive + Google Sheets

HourlyAI

Turn video ideas in a sheet into finished videos in Drive

Every hour the next ready idea in your Videos sheet becomes a video in your Drive, with the link and status written back to the sheet.

See how it works
Every 15 minutesAI

Turn invoices dropped in a Drive folder into expense rows

Any invoice or receipt you drop into a Drive folder becomes a row in your expenses sheet with supplier, date, amount and VAT.

See how it works
Every 15 minutesAI

Score CVs from a Drive folder into a spreadsheet

Every CV added to your Applicants folder becomes a row in your sheet with contact details, skills, experience and a score against the role.

See how it works

Build your own

Build any Gmail, Google Drive and Google Sheets automation you can describe

The workflows above are examples. Describe your own steps across Gmail, Google Drive and Google Sheets, plus any other app 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.

Setup

Connect each app once

Every workflow on this page uses the same connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Gmail

Email

  1. At console.cloud.google.com, create a project and enable the Gmail API under APIs & Services → Library.
  2. 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.
  3. Under Data Access, add the scopes you need, such as https://www.googleapis.com/auth/gmail.modify, or gmail.send if you only want to send.
  4. Under Clients, create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  5. 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 Drive

File storage

  1. At console.cloud.google.com, create a project and enable the Google Drive API.
  2. Set up the OAuth consent screen and add the scope https://www.googleapis.com/auth/drive.
  3. Create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  4. In the ClickRuntime dashboard, open Connections, choose Google Drive and enter the client ID and secret, then connect.
  5. Prefer a service account? Under IAM & Admin → Service Accounts, create one and add a JSON key, share your folders or a Shared Drive with its email, and save the key as a secret on Connections & secrets.

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.

FAQ

Questions about connecting Gmail, Google Drive and Google Sheets

Can it pick the folder from the email?
Yes. Describe the rule, for example the sender's domain, a word in the subject or a Gmail label, and the automation picks the folder from it.
Will it save the same attachment twice?
No. Automations keep a record of what they already processed, so each email is handled once.
How quickly does it pick up new emails?
It checks for new emails on the schedule you choose, as often as every 5 minutes.

Related pages

Keep exploring

Tell your assistant what Gmail, Google Drive and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude