Route social media content reviews with Google Gemini and Google Sheets Workflow Solution

Workflow overview

Why this workflow matters

Potentially useful as a reusable automation building block.

Quick overview This workflow collects a social media content brief via an AlekSystem form, uses Google Sheets for client brand context, and runs a three-stage human-in-the-loop process powered by Google Gemini (strategy angles, draft writing, and quality audit) before logging the approved post back to Google Sheets. How it works Receives a new content request through an AlekSystem Form that captures client, platform, content type, and optional topic and tone notes. Looks up the client’s brand fields in Google Sheets and combines them with the brief plus embedded brand and platform playbooks. Uses Google Gemini to generate three strategy angles, then pauses for a human to approve an angle or request revised angles with feedback. Uses Google Gemini to write a platform-specific draft (post copy, hashtags, and visual direction), then pauses for a human to approve or send revision notes to regenerate the draft. Sends the draft to Google Gemini for a structured quality audit, parses the returned JSON into readable fields, and pauses for a final human decision. If approved, updates a Google Sheets “Output” sheet with the published post; otherwise it routes feedback back to Marcus for revisions or back to Sofia to restart with new angles. Setup Connect Google Gemini (PaLM) credentials for the three Google Gemini chat/model steps. Connect a Google Sheets OAuth2 credential and update the spreadsheet ID and sheet/tab selections used for the client lookup and output update. Ensure your Google Sheet contains the expected brand fields (for example: brand_name, brand_voice, tone_linkedin/tone_x/tone_instagram, language_avoid, visual_style, key_messages) and an output sheet with a row_number and “Published Post” column. Review the three AlekSystem Forms (brief intake, Sofia review, Marcus review, and Taylor review) and adjust labels/options to match your internal approval process before activating the workflow.

Best fit

Need another direction?