Blogger - Sheet Automation

Sheet Automation turns a Google Sheet into a publishing queue. Each row becomes a Blogger post — you define the title, content, labels, status, and destination blog right in the spreadsheet, and Tenwrite handles the rest.

Because each row can target a different blog, a single sheet can manage content across all your Blogger blogs at once. This makes it particularly useful for bulk publishing and programmatic SEO.

Tenwrite checks your sheet once every hour. New rows create new posts. Rows that have changed update the existing post. Rows that are unchanged are skipped. Rows missing required fields are skipped without error.

The maximum is 500 rows per sheet.

Every row needs SITE, TITLE, and at least one of CONTENT or GOOGLE DOC. Use CONTENT for short posts written directly in the sheet. Use GOOGLE DOC for long-form content that lives in Google Docs.

If you’re using the GOOGLE DOC column, the referenced document needs to be readable by Tenwrite. There are two ways to do this:

Option A — Share with the service account:

Open the Google Doc, click Share, and add automation@tenwrite-gcp.iam.gserviceaccount.com as a Viewer. Click Share anyway if prompted.

Option B — Make the doc public:

In the Share dialog, change General access to Anyone with the link (Viewer) and click Done.

Open the Tenwrite add-on or Web Dashboard, go to Blogger > Automations, and switch to the Sheets tab.

Click New Automation (or Create Sheet Automation if none exist). The create form opens.

Click Select Google Sheet, choose your spreadsheet from the picker, and select the tab that contains your data.

Check Enable Automation Immediately if you want it to start on the next hourly run, then click Create Automation.

The Sheets tab lists all your automations with run stats — total runs, posts created, rows processed, failures — and when each last ran. Use the action button in each row to pause or resume.

Each row targets a different blog. Tenwrite processes all three in the same hourly run.

• Column names are case-sensitive — SITE, TITLE, CONTENT, GOOGLE DOC must match exactly.
• Every row needs SITE, TITLE, and at least one content column.
• If using GOOGLE DOC, make sure the doc is shared with the service account or set to public.
• Confirm the automation is enabled and the Blogger blogs are connected.

• Use exactly LIVE, DRAFT, or SCHEDULED — all uppercase.
• For scheduled posts, also set PUBLISH DATE to a future date in YYYY-MM-DD HH:MM format.

• If a doc has a Frontmatter table, it overrides the corresponding sheet columns. This is intentional — the doc’s own metadata takes priority.

• Document Frontmatter
• Drive Automation
• Export Google Docs to Blogger

Need help? Contact support@tenwrite.com.