Social Posting KitBuilt
Social Posting – Facebook Page via Zernio (Content Queue)
Approved rows in a Google Sheet content queue are published to a Facebook Page through Zernio on schedule, with the post ID written back.
Workflow file is complete and imports inactive. No live test is recorded in the files.
Flow
Every 15 Minutes
Manual Test Run
Config
Read Content QueueGoogle Sheets
Select Due Approved Posts
Lock Row (publishing)Google Sheets
Prepare Post
Publish via ZernioZernio
Mark PostedGoogle Sheets
Mark Failed + alertGoogle Sheets
TriggerApp stepLogic stepResult
How it works
- Every 15 minutes the workflow reads the queue tab of the content Sheet.
- It keeps rows that are approved, due now and meant for Facebook, up to a per-run limit.
- Each row is locked as publishing so it can't post twice.
- One HTTP call to Zernio publishes the post to the connected Facebook Page.
- The row is marked posted with its post ID, or failed with the error, and failures raise an alert for the error handler.
At a glance
Setup notes
- Create the content Sheet with a queue tab (id, platform, message, image_url, link, scheduled_at, status, post_id, error, posted_at).
- Create a Header Auth credential for the Zernio API key, and a Google Sheets credential.
- Connect the client's Facebook Page inside Zernio.
- Fill in Config with the Sheet ID and set the Error workflow to Social Posting – Error Handler.
- Test with one approved row that's due now, using Manual Test Run.
Good to know
Recommended way to sell: clients connect their Page through Zernio instead of creating a Meta app. Nothing posts unless a person sets a row to approved.