Skip to content
ClickRuntime

Connect Google Sheets to WordPress

A Google Sheet is the easiest place to plan a blog, and WordPress is where the posts live. Connect them and your content plan turns into drafts, your new posts become social captions, and pages get FAQs and summaries, with every step tracked in the sheet.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and WordPress

Blog drafts, summaries, FAQs and social captions moving between your Google Sheets and WordPress site. These are ready-made starting points. Anything else you can describe works too.
DailyAI

Turn a blog plan sheet into WordPress drafts

Each morning the next topic in your blog plan sheet becomes an SEO article draft in WordPress, with the link written back to the sheet.

See how it works
Every hourAI

Write social captions for new WordPress posts in a sheet

Each time you publish a blog post, captions for LinkedIn, X and Facebook are written and added to your social queue sheet, ready to schedule.

See how it works
Every hourAI

Add FAQ sections to WordPress pages listed in a sheet

List a page in your FAQ sheet and five questions and answers written from its content are added to the bottom of the page, with the row marked done.

See how it works
On a scheduleAI

Add a short summary to the top of every WordPress post

Every night, posts without a summary get a three-line summary at the top, and each one is logged in a sheet so you can see what has been done.

See how it works
Every 6 hoursAI

Turn new items from your sources into WordPress drafts

New articles and videos from the feeds in your Sources sheet become original blog drafts in WordPress, each one logged in the sheet.

See how it works
WeeklyAI

Turn this week's trending searches into WordPress drafts

Every Monday the week's rising searches in your niche are logged in a sheet and the top three become blog drafts in WordPress.

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

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and WordPress 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 create posts for rows with a keyword and category, and skip rows already linked to a post.

Each Monday, update the sheet with each post's status and comment count.

Use cases

Why people connect Google Sheets and WordPress

How the two apps work together

  • A check every few minutes finds rows that are ready.
  • The script creates or updates WordPress posts through the REST API.
  • It writes the post URL and status back to the row.

  • Bloggers planning content

    A sheet of topics becomes WordPress drafts. Writing starts from structure.

  • SEO teams scaling pages

    Rows with keywords become posts. Publishing scales.

  • Agencies managing several blogs

    One sheet feeds posts to different sites. Coordination is simpler.

  • Editors tracking posts

    Published posts are logged with URL and date. Reporting is easy.

More apps

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

Draft with AI

For each topic row, write a post with OpenAI and create a WordPress draft.

Draft ready

Post the draft link to #content when a row creates a WordPress post.

Share on publish

When a post from my sheet is published, share it on LinkedIn.

Setup

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

WordPress

CMS

  1. In wp-admin, go to Users and open your profile, or the profile of the user the automation should act as.
  2. Scroll to Application Passwords, type a name such as ClickRuntime, and choose Add New Application Password.
  3. Copy the generated password straight away, along with the WordPress username it belongs to.
  4. In the ClickRuntime dashboard, save the username and Application Password as a secret on Connections & secrets, together with your site address.

FAQ

Questions about connecting Google Sheets and WordPress

How does ClickRuntime sign in to WordPress?
With an application password, which you create under your user profile in WordPress. It is saved as a secret in your ClickRuntime dashboard and can be revoked at any time.
Will posts go live without me checking?
Not unless you ask for it. These automations create drafts by default, so you can read and edit each post before publishing.
Does it work with WordPress.com?
Yes, on plans that allow application passwords, as well as any self-hosted WordPress site with the REST API turned on, which is the default.
Can I use my own sheet layout?
Yes. Tell it which tab and columns hold the topic, status and link, and it reads and writes those.
Can it set categories and tags?
Yes. Columns can map to categories and tags.
Can it schedule posts?
Yes. Set a future date and WordPress publishes then.
Can it update existing posts?
Yes. Rows with a post ID update that post.

Related pages

Keep exploring

Tell your assistant what Google Sheets and WordPress should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude