Skip to content
ClickRuntime

Connect Google Sheets to Trello

Sheets are good for lists and numbers, and Trello is good for work that moves through stages. Connect them so rows become cards someone can pick up, and the state of your board is logged back to a sheet for reporting.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and Trello

Rows turned into Trello cards, and board snapshots saved to Sheets. These are ready-made starting points. Anything else you can describe works too.
Every 15 minutes

Turn new rows in a sheet into Trello cards

Each new lead or client added to your sheet becomes a Trello card, and the card link is written back to the row.

See how it works
Every 15 min or incoming webhookAI

Log every review to a sheet and send bad ones to Trello

Each new review is classified by AI and logged to your sheet, and negative ones become Trello cards for follow-up.

See how it works
Daily

Log a daily snapshot of your Trello board to Google Sheets

Every evening each card on your board is saved as a dated row with its list, due date and members, so you can see how work moved over weeks.

See how it works
DailyAI

Turn your daily sales sheet into Trello follow-ups

Each day your sales figures are reviewed and the follow-ups worth doing arrive as Trello cards.

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 and Trello, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and Trello automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and Trello 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 evening, write every card on my board to a sheet tab, and highlight in a column cards that have been in the same list for over 7 days.

When a row's Status column changes to Done, move the matching Trello card to Done, but only if the card has no unchecked checklist items.

Use cases

Why people connect Google Sheets and Trello

How the two apps work together

  • The automation checks the sheet every few minutes for new or changed rows.
  • Rows become Trello cards with name, description, due date and labels, and the card URL is written back.
  • Trello webhooks or a scheduled read update the sheet when cards move or change.

  • Board reports in a spreadsheet

    Managers keep a sheet of all cards with list, members, labels and due dates. They filter and chart it in ways the board does not allow.

  • Bulk card creation

    Event planners and agencies build a task list in a sheet and turn each row into a Trello card with checklists.

  • Content plans to boards

    Social media managers plan posts in a sheet with date, channel and copy columns. Each row becomes a card on the content board.

  • Throughput tracking over time

    Team leads log how many cards reach Done each week in a sheet. It shows workload trends across months.

More apps

Google Sheets, Trello 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.

Sheet rows to cards with Slack notice

When a row in my Tasks sheet is marked Ready, create a Trello card and post it in #team.

Form submissions to Sheets and Trello

When a Google Forms response arrives in my Requests sheet, create a Trello card in the Incoming list.

Hours per card in a sheet

Every week, add the Harvest hours logged against each Trello card name to my Project Hours sheet.

Setup

Connect Google Sheets and Trello 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 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.

Trello

Project management

  1. In Trello, go to trello.com/apps/admin and create a new Power-Up.
  2. On its Trello Auth tab, generate a new API key.
  3. Click the Token link next to the key, choose Allow and copy the token.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the API key and token as secrets for Trello.

FAQ

Questions about connecting Google Sheets and Trello

Will a row create a card more than once?
No. Each row is handled once. Rows you add later are picked up on the next run.
Can sheet columns fill in card details?
Yes. Columns such as name, description, due date and label can map to the card's fields.
What does a board snapshot include?
One row per card with its list, labels, due date and members, plus the date of the snapshot. Over time that gives you a history to chart.
How do I connect the two?
Google Sheets connects through your own Google account. Trello uses an API key and token saved as secrets in your ClickRuntime dashboard.
Can sheet edits move cards?
Yes. If the row holds the card ID, the script can move the card when a list or status column changes.
Can I export several boards to one sheet?
Yes. The script can read any boards your Trello connection can access and add a board column.
What happens to cards that already exist?
A first run can import them, or the automation can start with only new cards.

Related pages

Keep exploring

Tell your assistant what Google Sheets and Trello should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude