Every day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.
Uses
Claude
Gmail
Google Sheets
Drip helpful articles to your leads
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 0Yes
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 0Yes
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 0Yes
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 emptyYes
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 writeErrorTry
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 emptyYes
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 articleUrlYes
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 0Yes
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 recordErrorTry
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 noYes
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 sendErrorTry
GmailSend an email to leadEmail.Send an email to leadEmail.
Subject: articleTitleemailBodyAdd 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.