Skip to content
ClickRuntime

Connect Google Drive to Google Sheets

Drive holds the files and a sheet keeps the list. Pull details out of invoices and CVs dropped in a folder into rows, and turn rows into documents, images or folders in Drive, with links written back so the sheet stays the index.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Drive and Google Sheets

File extraction, logging and document generation between Drive folders and a Google Sheet. These are ready-made starting points. Anything else you can describe works too.
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
DailyAI

Turn a sheet of topics into article drafts in Drive

Each day the next topic in your Content sheet becomes a 1,000-word article draft in Google Docs, with its link added to the sheet.

See how it works
Every 15 minutesAI

Write social captions for images you drop in Drive

Each image you add to your Drive Posts folder gets a caption and hashtags in your Content sheet, ready to post.

See how it works
DailyAI

Log job postings that match your CV in a sheet

Each morning, new postings from your job feeds are scored against your CV and the good matches are added to your Jobs sheet.

See how it works
Every 30 minutesAI

Generate images from prompts in a sheet and save them to Drive

Each new prompt you add to your Images sheet becomes an image in your Drive, with the link added to the row.

See how it works
The moment it happens

Save incoming files to Drive and log them in a sheet

Files sent to your trigger link are saved in your Drive 'Inbox' folder and listed in a sheet with name, sender, date and link.

See how it works
The moment it happens

Create PDF invoices from your order form

Each order from your form gets a numbered PDF invoice saved to Drive and a row in your Invoices sheet.

See how it works
The moment it happens

Log your arrival and departure times automatically

Your phone records each time you arrive at or leave work in a Google Sheet, and last month's log is saved to Drive on the 1st.

See how it works Your own logic

Any other automation you can describe in words

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

See how to build your own

More ideas

WeeklyAI

Turn new words in your vocabulary sheet into Anki flash cards

Every Sunday the new words in your Vocab sheet get a translation, pinyin and an example sentence, and a ready-to-import Anki file is saved to Drive.

See how it works
Every 15 minutes

Create a Drive folder for each new hire in your roster

New rows in your Onboarding sheet get their own Drive folder from your template, shared with the new hire, with the link written back.

See how it works
On a schedule

List Google Drive folder files in Google Sheets

A sheet tab keeps an index of every file in a Drive folder and its subfolders, with folder path, type, owner, last modified and link.

See how it works
Every 15 minutes

Import new Drive CSV files into Google Sheets

CSV files dropped into a Drive folder are appended to one Google Sheets tab, with the file name on every row.

See how it works

Build your own

Build any Google Drive and Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Drive and Google Sheets 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, read new receipts in my Drive Receipts folder with AI and add the vendor, date, total and category to my Expenses sheet, skipping files already listed.

Each Monday, check my Clients sheet and create any missing Drive folders with subfolders for Contracts, Invoices and Deliverables.

Use cases

Why people connect Google Drive and Google Sheets

How the two apps work together

  • ClickRuntime checks Drive folders every few minutes for new or changed files.
  • File details, or data pulled from the file content, are written as rows in a sheet.
  • Rows in the sheet can also start actions in Drive, such as creating folders or copying templates.

  • Finance logs every invoice file

    New PDFs in an Invoices folder are read and added as rows with vendor, date and total. The sheet is ready for reconciliation.

  • Ops keeps an index of shared files

    A sheet listing every file in a project folder with owner, modified date and link helps teams audit what's there.

  • Agency creates client folders from a list

    Adding a client row to a sheet can create a matching folder set in Drive and write the link back.

  • Recruiter screens resumes into a sheet

    Resumes saved in Drive can be read with AI and logged with name, skills and years of experience.

More apps

Google Drive, Google Sheets and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

New Drive invoices logged and announced

When an invoice is added to my Drive folder, log its total in my Invoices sheet and post it to #finance in Slack.

Sheet rows to Docs saved in Drive

For each new row in my Clients sheet, create a contract from my Google Docs template and save it to the client's Drive folder.

Email a weekly file index

Every Friday, update my Files sheet with what changed in Drive this week and email me the list from Gmail.

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.

More with these apps

Setup

Connect Google Drive and Google Sheets once

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

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 Google Drive and Google Sheets

Will it process the same file twice?
No. It remembers which files it has handled, and writes the file link to the sheet so each one appears once.
Which file types can it read?
PDFs, Google Docs and common image formats. Scanned documents work best when the text is clear.
Do I need a particular sheet layout?
No. You choose the tab and columns, and it writes to those.
Where do generated files go?
Into the Drive folder you name, with the file link added to the matching row.
Can it read scanned PDFs and images?
It can use the built-in AI to read text from many scans and images, though very poor scans may need checking.
How often does it check the folder?
As often as every 5 minutes, or on any slower schedule.
Will it update rows when a file changes?
Yes, if you ask. It can track each file ID and update the matching row instead of adding a new one.

Related pages

Keep exploring

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

Free plan. No credit card.

Add to ChatGPTAdd to Claude