📘 Zapier AI Agent Setup — Full Flow (No Code Required)

0) Prerequisites

• Sign in to Zapier, Google Sheets, Google Docs, and Gmail.
• Recipient email:————————

1) Create the Google Sheet

1. In Google Drive, create a Google Sheet named Content Research Log.
2. Add these columns in row 1, left to right:
   • Date
   • Idea Title
   • Summary
   • Hook
   • Why Trending
   • Status
   • Notes

2) Create a Google Drive folder for outputs

1. In Google Drive, create a folder named Repurposed Content.
2. You’ll store the generated Google Docs here.

3) Create the Agent

1. Go to Zapier → Agents → New Agent → Custom Agent.
2. Name it: Daily Content Research + Repurpose.

4) Paste the prompt (do this before connecting tools)

Paste this text into the agent’s Behavior/Instructions field exactly as written:

Every day, use web search to scan trending content in my niche. Identify five ideas from top-performing posts. For each idea, provide:

A short summary of the topic

One scroll-stopping hook

A simple description of why it is trending

Log the five ideas, summaries, and hooks into a Google Sheets file.

After logging them, email me a summary of the five ideas using Gmail and wait for my reply.

Only continue if I reply with the word APPROVED.

After approval, take the top idea and repurpose it into:
– An Instagram Reel script
– A carousel outline (slide-by-slide)
– An X thread

Create a Google Doc containing the repurposed content and email me the document link when complete.

Do not repurpose content until approval is received.

5) Connect only these tools

Enable:

• Web Search