From one keyword to five channels: SisterLove's AI content pipeline
SisterLove (18-person Atlanta nonprofit), Brison Edwards, Digital Marketing Manager
Brison Edwards, the first digital marketing manager at SisterLove, an 18-person nonprofit in Atlanta, built a workflow where one row in a Google Sheet starts AI drafts for five channels at once. Work per topic fell from six to eight hours to minutes, according to Zapier's 2023 customer story.
Story written by: the tool's company
The problem
SisterLove, a small nonprofit, had to move its work online fast at the start of the COVID-19 pandemic, with a tiny team and budget. Brison Edwards, its first Digital Marketing Manager, spent six to eight hours on content for each topic across channels. That one task ate the time he needed for everything else.
How it was built
- 1Enter a keyword in a Google SheetGoogle Sheets
- 2The filled row triggers a ZapZapier
- 3OpenAI writes the blog draftOpenAI
- 4The Zap files the draft on the right rowZapier
- 5One row feeds five channelsPerson
- 6A Google Form opens the workflow to the teamGoogle Forms
Tool step Person step
1. Enter a keyword in a Google Sheet
Brison types a keyword or phrase into Google Sheets, filling the first four columns of a content row; the later columns hold each channel's output.
ToolGoogle Sheets
2. The filled row triggers a Zap
The filled row triggers Zapier to send a prompt to OpenAI asking for an 800-1000 word blog post from those keywords, in the organization's brand voice.
ToolZapier
3. OpenAI writes the blog draft
OpenAI answers the prompt with a full blog draft, so nobody has to write the first version by hand.
ToolOpenAI
4. The Zap files the draft on the right row
Zapier then looks up the spreadsheet row for that keyword and copies the drafted blog into the correct column, with no copy-pasting by hand.
ToolZapier
5. One row feeds five channels
From the same row, Zapier and OpenAI also produce an email, an outline for a short video, social media captions and text messages.
6. A Google Form opens the workflow to the team
Brison connected a Google Form to the content tool, so colleagues can submit ideas that he runs through the same workflow.
ToolGoogle Forms
Before and after
Before
Each content topic took six to eight hours of manual work across channels.
After
The same work takes minutes, and the workflow saved more than 24 business days (over 190 hours) in under nine months (self-reported). source
What made it work
- One keyword row in Google Sheets starts the whole workflow, so there is a single place to begin.
- Zapier passes the prompt to OpenAI and files the answer back on the right row, so no copy-pasting.
- A single run drafts five channels at once: blog, email, video outline, social captions and text messages.
- A Google Form lets the whole team submit ideas, so content ideas no longer sit with one person.
- Zapier's nonprofit discount kept the setup affordable on a small budget.
Follow along
Practice steps suggested by Ai Siftly, based on the account above. We have not run them ourselves.
Example to copy: row_id | topic | audience | approved_facts | brand_voice | status | blog_draft | reviewer. Test ID: TEST-001.
You should get: One non-sensitive test row.
Check: No private health data; reviewer named.
Example to copy: Write a draft for [audience] about [topic] using only [approved facts], in [voice]. Mark missing evidence CHECK. Do not invent statistics or health advice.
You should get: Unpublished draft.
Check: A person checks every factual and health claim against suitable authoritative evidence.
You should get: Draft in correct row.
Check: Other rows unchanged and nothing published.
Example to copy: Adapt this approved text into a short email. Preserve facts/call to action; add no claims. [text]
You should get: Separate reviewed email draft.
Check: No factual drift, privacy issue or automatic send.
Example to copy: Ready-status gate -> Conversation -> find exact row ID -> write draft column -> Needs review. Never publish/send.
You should get: A designed automation and permission/cost checklist.
Check: The trigger column is not changed by the output writes, so no retrigger loop. The API key lives only in the connection secret field, never in a sheet or prompt.
You should get: Test log or decision to stay manual.
Check: No duplicate runs or wrong-row writes. Missing facts stop the run or ask; live publication stays off.
Try it yourself
Find a matching workflow in the workflow finder. Search words: Z a p i e r O p e n A I G o o g l e S h e e t s c o n t e n t w o r k f l o w.
Sources and notes
- SisterLove scaled content creation with AI and automation (Zapier blog (Grace Miller), 2023-11-13)
- Choosing the current OpenAI action (Zapier, )
- Preventing unexpected Sheets triggers (Zapier, )
- Find and update rows (Zapier, )
- All results are self-reported: they come from a Zapier customer story by Grace Miller, published November 13, 2023.
- The story does not share the exact sheet columns or the prompt text.
- The claim about ranking number one in organic search does not name the keywords.
- Running this as automation today needs a paid multi-step Zapier plan and prepaid OpenAI API billing, which is separate from a ChatGPT subscription; check availability in your country.
- The practice steps are a suggested learning exercise from Ai Siftly, not SisterLove's exact process.
Vendor-published Prompt and sheet columns not disclosed Search ranking claim unspecific; story is from 2023. Date note: 2023-11-13. Record dated 2026-10-27.