Skip to content
ClickRuntime

Connect Google Sheets to X

A Google Sheet is the simplest content calendar there is, and X rewards people who post often. Connecting the two lets you plan posts in rows, have them go out on time, and keep a log of what was posted and how it performed.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and X

Post from a sheet on a schedule, log what went out, and track how your posts perform. These are ready-made starting points. Anything else you can describe works too.
DailyAI

Publish your sheet content plan to X

Posts planned in your Google Sheet are written up by AI and published on X on the day you scheduled them.

See how it works
Every hourAI

Announce new articles and videos on X

Each new blog post or YouTube video gets its own post on X, and every announcement is logged in your sheet.

See how it works
Every 3 hours

Post to X from a spreadsheet queue

Write posts in a sheet whenever you like, and they go out on X one at a time, every few hours.

See how it works
DailyAI

Post a daily themed update on X

Each day a post about today's occasion, local weather or top news goes out on X, with a history kept in your sheet.

See how it works
Weekly

Track your X post performance weekly

Every week your posts' views, likes and reposts are saved to a sheet, and you get an email with the highlights.

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 X, 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 X automation you can describe

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

Before posting, check the text is under 280 characters; if not, have AI shorten it and save the new version in the sheet.

Each Sunday, look at my metrics sheet and post one X thread about the biggest change from the previous week.

Use cases

Why people connect Google Sheets and X

How the two apps work together

  • A check every few minutes reads the sheet for due rows that are not yet posted.
  • The script posts the text to X and writes the post ID and time back to the row.
  • Optionally, it reads public metrics for each post on a schedule and fills in the sheet.

  • Marketers running a post queue

    A sheet holds posts with a date and time. They are posted on schedule and marked done.

  • Founders sharing metrics

    Numbers in a sheet, such as signups or revenue, are turned into a weekly post on X. Building in public takes less work.

  • Teams tracking post performance

    Likes and reposts for each post are written back to the sheet. The team sees what worked.

  • Newsletter writers promoting issues

    Each issue row becomes a short post with a link. Readers on X get a reminder.

More apps

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

Images from Drive

For each due row in my sheet, attach the image named in the "image" column from my Drive folder and post it to X.

Post to X and LinkedIn

Post each due row to X and a longer version to LinkedIn, and mark both columns.

Posted confirmation in Slack

After each row is posted to X, post the link to #marketing.

Setup

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

X

Social

  1. In the X Developer Console, create an app and buy credits.
  2. Under User authentication settings, choose OAuth 2.0 as a Web App (confidential) with the callback https://clickruntime.com/oauth/callback.
  3. Use the scopes tweet.read, tweet.write, users.read and offline.access, adding media.write for images.
  4. Enter the client ID and secret under Connections in the ClickRuntime dashboard. You can use an OAuth 1.0a consumer key and access token for your own account instead.

FAQ

Questions about connecting Google Sheets and X

How do I plan posts in the sheet?
Put one post or idea per row, with a date or a status column such as Ready. The automation reads the rows that are due and marks each one once it is posted.
Does it write the posts or use my exact text?
Either. If a row holds finished text it is posted as written; if it holds an idea, AI writes the post from it within X's length limit.
Which X account do posts go to?
The account you connect when you set it up. You can connect a second account and name it separately if you post for more than one brand.
Are there limits on how often I can post?
X sets posting limits based on your API access level. Posting a few times a day from a sheet stays well within them.
Can it post threads from the sheet?
Yes. Put each part in its own column and it posts them as a thread.
What if a row fails to post?
The script writes the error to a status column and can retry on the next run.
Can I pause the queue?
Yes. Pause the automation in the ClickRuntime dashboard, or mark rows as on hold.

Related pages

Keep exploring

Tell your assistant what Google Sheets and X should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude