Skip to content
ClickRuntime

Connect AWS to Google Sheets

Files land in S3, but people track work in Google Sheets. Connecting them gives you a readable log of what's in your buckets, from transcripts of uploaded audio to archived pages and supplier documents, without anyone opening the AWS console.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with AWS and Google Sheets

Transcripts, page archives and document data moving between S3 and your sheets. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutes

Transcribe audio uploaded to S3 into a Google Sheet

Every audio file you upload to your S3 bucket is transcribed, and the file name and transcript are added as a row in your sheet.

See how it works
On a schedule

Archive the pages in your sheet to S3 every month

On the 1st of each month, every page listed in your sheet is saved to S3 under that month's date, and the archive path is written back next to it.

See how it works
Every 15 minutesAI

Save supplier attachments to S3 and log their details in a sheet

Attachments from your suppliers' emails are saved to S3, and the invoice number, date and total from each one are added to your sheet with a link to the file.

See how it works Your own logic

Any other automation you can describe in words

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

See how to build your own

Build your own

Build any AWS and Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between AWS 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

Only list S3 files over 10 MB and mark any not accessed in 90 days as "archive candidate".

Each night, export every tab of my sheet to CSV and save it to S3 with the date in the file name.

Use cases

Why people connect AWS and Google Sheets

How the two apps work together

  • A schedule or a check every few minutes reads S3 buckets or AWS cost data using your keys.
  • The script writes rows to Google Sheets.
  • On a schedule, it reads sheet data and saves files to S3.

  • Engineers tracking cloud costs

    Daily AWS cost by service is written to a sheet. Spikes show up in a chart.

  • Teams keeping an S3 inventory

    New files in an S3 bucket are listed with size and date. Non-engineers can see what was uploaded.

  • Ops teams storing backups

    Sheet data is saved to S3 as CSV each night. There is a copy outside Google.

  • Analysts processing uploads

    Files dropped in S3 are read and results written to a sheet. Data is ready to review.

More apps

AWS, 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.

Cost alert

Each day, add AWS cost by service to my sheet and post to #ops if any service is 50 percent above its 7-day average.

Weekly cost email

Every Monday, email me last week's AWS costs from my sheet with the top 5 services.

Describe new images

For each new image in my S3 bucket, describe it with OpenAI and add the description to my Google Sheet.

Setup

Connect AWS 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.

AWS

Developer / Cloud infrastructure

  1. In the IAM console, create a user without console access just for ClickRuntime.
  2. Attach a minimal policy, for example s3:GetObject, s3:PutObject and s3:ListBucket on one bucket ARN, plus ce:GetCostAndUsage or Textract and Transcribe actions only if you use those automations.
  3. Open the user, go to Security credentials, choose Create access key and select Application running outside AWS.
  4. Copy the Access key ID and Secret access key, then save them with your region as secrets on Connections & secrets in the ClickRuntime dashboard.

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

How does ClickRuntime access my AWS account?
With an IAM access key you save as a secret in your ClickRuntime dashboard. Create a user limited to the bucket and services the automation needs.
Does it make my S3 files public?
No. Files stay private, and links written to the sheet are either S3 paths or time-limited download links.
Which AWS region does it use?
Whichever region your bucket is in. You set it once in the script.
Will the AWS calls cost money?
AWS charges its usual rates for storage and services such as Transcribe. Listing and uploading a few files costs very little.
What IAM permissions should the key have?
Only what the script needs, such as s3:GetObject and s3:ListBucket for one bucket, or ce:GetCostAndUsage for costs.
Does reading cost data cost money?
AWS charges a small fee per Cost Explorer API request. A daily check uses very few.
Can it use more than one bucket?
Yes. List the buckets and the script reads each.

Related pages

Keep exploring

Tell your assistant what AWS and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude