Vet Instagram creators in Sheets and draft Gmail outreach

Build me an agent workflow that runs on a cron every weekday at 9am in my local timezone and turns my raw Instagram outreach queue into vetted, personalized Gmail drafts. I keep a Google Sheet with a tab called Outreach Queue. Each row has these columns: handle (Instagram username, with or without the @), pitch_note (a short campaign angle written by me), email (may be blank), status, and empty columns for follower_count, engagement_rate, credibility, top_country, and top_interest. Only rows that have a handle and a pitch_note but an empty status should be picked up on each run.

For each eligible row, call Modash Get Instagram Influencer Report using the handle from that row. From the report, extract follower count, engagement rate, credibility score (also called fake follower score), the single top audience country by share, and the single top interest by share. Write those five values back into the matching row using Google Sheets Update Values so I can see them next to the handle.

Then apply thresholds. Expose two configurable variables at the top of the workflow: MIN_CREDIBILITY (default 0.7) and MIN_ENGAGEMENT (default 0.01, meaning 1 percent). If either the credibility is below MIN_CREDIBILITY or the engagement rate is below MIN_ENGAGEMENT, update the row status to low credibility, skip and move on to the next row. Do not draft an email for that creator.

For rows that pass both thresholds, generate a personalized outreach email and save it as a Gmail draft via Gmail Create a Draft. The draft should be addressed To the value in the email column if it is populated, and left with no recipient otherwise (still create the draft so I can add the address later). The tone of the email should stay consistent with the pitch_note I wrote for that row (do not rewrite my angle, build the email around it). Reference at least one specific fact from the Modash report, for example their follower count tier, their top audience country, or their top interest, so the message clearly reads as researched and not templated. Keep the draft short (roughly 90 to 130 words), sign off with the sender name from the connected Gmail account, and use a subject line that mentions the creator by their handle or the pitch angle.

After the draft is created, update the row status to drafted, ready to review so I know which rows are waiting on me. Move on to the next eligible row. If a Modash lookup fails for any reason (handle not found, rate limit, out of credits, timeout), set the row status to lookup failed and continue with the remaining rows instead of halting the whole run.

At the end of the run, log a one-line summary of how many rows were processed, how many drafts were created, how many were skipped for low credibility, and how many failed lookup. No Slack or email notification is needed, the sheet is the source of truth. Do not send any emails; only create Gmail drafts.