Drip helpful articles to your leads

Every morning, the next few leads in your spreadsheet each get an email sharing one article from your list, chosen at random from the ones they have not had yet. The AI writes a short note on why it might be worth their time, from the facts on the lead's row and the article's row and nothing else, and it goes out from your Gmail with the article's title as the subject and your own sign-off and opt-out line added. Each follow-up carries something useful instead of a 'just checking in'.

The list is worked through a few leads a day. Whoever has never had an article goes first, in sheet order, then whoever was emailed longest ago, and nobody hears from you again until the gap you set has passed. Every send is written to a record tab before the email leaves and read back at the start of each run, so a rerun cannot repeat a send and nobody gets the same article twice.

Before the first run you need a leads tab with Email and Name columns, an articles tab with Title and URL columns (a Summary column helps the note), an empty record tab headed Email, Article, URL and Sent at, and a short description of who the emails come from.

Run every day at 09:00.Run every day at 09:00.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set leadsTabName to blank.Set leadsTabName to blank.

Set articlesTabName to blank.Set articlesTabName to blank.

Set sentTabName to blank.Set sentTabName to blank.

Set senderContext to blank.Set senderContext to blank.

Set signOff to blank.Set signOff to blank.

Set optOutLine to If you would rather not get these, just reply and say so..Set optOutLine to If you would rather not get these, just reply and say so..

Set leadsPerDay to 5.Set leadsPerDay to 5.

Set daysBetweenEmails to 7.Set daysBetweenEmails to 7.

Set secondsBetweenEmails to 5.Set secondsBetweenEmails to 5.

Google SheetsRead the rows of spreadsheetUrl. Save it as leadsRead.Read the rows of spreadsheetUrl. Save it as leadsRead.

Google SheetsRead the rows of spreadsheetUrl. Save it as articlesRead.Read the rows of spreadsheetUrl. Save it as articlesRead.

Google SheetsRead the rows of spreadsheetUrl. Save it as sentRead.Read the rows of spreadsheetUrl. Save it as sentRead.

If articlesRead.count is 0If articlesRead.count is 0

Yes

Stop and report a problem: The articles tab is empty. Add at least one row with a Title and a URL, and optionally a Summary, then run again.Stop and report a problem: The articles tab is empty. Add at least one row with a Title and a URL, and optionally a Summary, then run again.

No

No steps

If leadsRead.count is 0If leadsRead.count is 0

Yes

Finish the run: The leads tab has no rows under its header, so there is nobody to email today.Finish the run: The leads tab has no rows under its header, so there is nobody to email today.

No

No steps

Run Python code on leads, articles, sent, now_text, leads_per_day, and days_between and save it as plan.Run Python code on leads, articles, sent, now_text, leads_per_day, and days_between and save it as plan.

For each note in plan.notes:For each note in plan.notes:

Show in the output: note.Show in the output: note.

If plan.articles is 0If plan.articles is 0

Yes

Stop and report a problem: None of the rows on the articles tab could be used - each needs a Title and a URL starting with http. Nothing was sent.Stop and report a problem: None of the rows on the articles tab could be used - each needs a Title and a URL starting with http. Nothing was sent.

No

No steps

If plan.picks is emptyIf plan.picks is empty

Yes

Finish the run: No lead is due an article today. Nothing was sent.Finish the run: No lead is due an article today. Nothing was sent.

No

No steps

Set sentCount to 0.Set sentCount to 0.

Set skippedCount to 0.Set skippedCount to 0.

Set failedCount to 0.Set failedCount to 0.

For each pick in plan.picks:For each pick in plan.picks:

Set leadEmail to pick.email.Set leadEmail to pick.email.

Set articleTitle to pick.title.Set articleTitle to pick.title.

Set articleUrl to pick.url.Set articleUrl to pick.url.

Set emailBody to blank.Set emailBody to blank.

If a step below fails, save the error as writeErrorIf a step below fails, save the error as writeError

Try

ClaudeAsk Claude: 'You are writing a short, friendly email on behalf of a person to one of their sales leads, sharing a link the person thinks the lead will find useful. It is a helpful touchpoint between conversations - not a pitch, and not a 'just checking in' message.Ask Claude: 'You are writing a short, friendly email on behalf of a person to one of their sales leads, sharing a link the person thinks the lead will find useful. It is a helpful touchpoint between conversations - not a pitch, and not a 'just checking in' message. Use ONLY the facts below. Do not invent anything about the lead, their company or the article beyond what is written here. Never imply you have spoken or met before - no 'as we discussed', no 'following up on our call'. Do not add pricing, offers or deadlines. About the sender and what they do: senderContext The lead: pick.facts The article to share: pick.article_facts Write the email body only, as plain text with no subject line, no markdown and no sign-off (the sender's own sign-off is added afterwards). Start with 'Hi ' followed by the lead's first name and a comma. Then two or three short paragraphs: one line on why this seemed worth sending them, what it covers in a sentence or two drawn only from the summary, and the link on its own line exactly as written above. Close with one light sentence that leaves the door open, with no pressure. Keep the whole thing under 150 words.'. Save it as written. Maximum response length: 600

Trim written.response_text and save it as emailBody.Trim written.response_text and save it as emailBody.

On error

Show in the output: Could not write the note for leadEmail: writeError as text.Show in the output: Could not write the note for leadEmail: writeError as text.

If emailBody is emptyIf emailBody is empty

Yes

Show in the output: No note came back for leadEmail, so they are left for the next run.Show in the output: No note came back for leadEmail, so they are left for the next run.

Add 1 to skippedCount.Add 1 to skippedCount.

Skip to the next item.Skip to the next item.

No

No steps

If emailBody doesn't contain articleUrlIf emailBody doesn't contain articleUrl

Yes

Change emailBody to emailBodyChange emailBody to emailBody articleUrl.

No

No steps

Change emailBody to emailBodyChange emailBody to emailBody signOff optOutLine.

If sentCount is greater than 0If sentCount is greater than 0

Yes

Wait for secondsBetweenEmails seconds.Wait for secondsBetweenEmails seconds.

No

No steps

Set recorded to false.Set recorded to false.

If a step below fails, save the error as recordErrorIf a step below fails, save the error as recordError

Try

Google SheetsAdd a row to sentTabName in spreadsheetUrl.Add a row to sentTabName in spreadsheetUrl.

Change recorded to true.Change recorded to true.

On error

Show in the output: Could not record the send for leadEmail on the '@sentTabName' tab, so nothing was sent to them: recordError as text.Show in the output: Could not record the send for leadEmail on the '@sentTabName' tab, so nothing was sent to them: recordError as text.

If recorded is noIf recorded is no

Yes

Add 1 to skippedCount.Add 1 to skippedCount.

Skip to the next item.Skip to the next item.

No

No steps

If a step below fails, save the error as sendErrorIf a step below fails, save the error as sendError

Try

GmailSend an email to leadEmail.Send an email to leadEmail. Subject: articleTitleemailBody

Add 1 to sentCount.Add 1 to sentCount.

Show in the output: Sent '@articleTitle' to leadEmail.Show in the output: Sent '@articleTitle' to leadEmail.

On error

Add 1 to failedCount.Add 1 to failedCount.

Show in the output: Recorded but could not send '@articleTitle' to leadEmail: sendError as text - delete that row from the '@sentTabName' tab to try again next run.Show in the output: Recorded but could not send '@articleTitle' to leadEmail: sendError as text - delete that row from the '@sentTabName' tab to try again next run.

Show in the output: Sent sentCount as text article email(s), failedCount as text failed to send, skipped skippedCount as text, out of the length of plan.picks as text lead(s) in today's batch.Show in the output: Sent sentCount as text article email(s), failedCount as text failed to send, skipped skippedCount as text, out of the length of plan.picks as text lead(s) in today's batch.