Generate two content briefs into a Google Sheet
At a glance
Helly uses Claude's API and Google Apps Script to turn a content calendar into a queue of reviewable briefs. This workflow is listed under Content Planning, Spreadsheets, Automation.
- Agents / tools
- Claude API, Google Sheets, Google Apps Script
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Create a Google Sheet tab named Content Calendar with columns for date added, publication date, title, keyword, angle, five FAQs, content type, difficulty and status. Have an Anthropic API account and key ready. 2) In Extensions > Apps Script, implement a function that sends a POST to https://api.anthropic.com/v1/messages with x-api-key, anthropic-version 2023-06-01 and JSON content headers. Use model claude-haiku-4-5-20251001, max_tokens 1500 and a user message requesting exactly two briefs as a JSON array. Specify your niche and the columns' corresponding fields. 3) Parse the API response, then parse content[0].text as JSON. Append one row per brief with today's added date, an empty publication date and status suggested. 4) Run the function manually, approve the requested permissions and inspect the rows. Edit or reject briefs before marking accepted ones approved.
Worth knowing
The source generates briefs; the author still writes the posts. The first run can be manual without a weekly trigger.