Send Daily Social Lead Digest
Scans social media comments from Google Sheets daily, identifies high-intent prospects using AI, and emails a styled digest of hot leads ready for outreach.
Lead GenerationGoogle SheetsGmailSocial Media
Daily Social Lead Email Digest
This workflow turns social media comments into actionable sales leads on autopilot. Each day, it fetches recent comments from a Google Sheet, uses an AI agent to pinpoint high-intent prospects, and sends you a clean, easy-to-read digest email highlighting hot leads ready for outreach.
It does four things:
- Runs daily at 8:30 AM IST to start the process automatically.
- Retrieves up to 50 recent comments from your configured Google Sheet.
- Uses an AI agent to analyze each comment, filtering for high-intent leads based on keywords and phrases.
- Sends a single HTML email to your Gmail with a summary and clickable links to the profiles of those hot leads.
What You Need
- A Google account with a Google Sheet holding your social media comments in the required format (see below).
- A Needle platform account set up with:
- Access to the Google Sheets connector (with permission to read your sheet).
- Gmail connector authorized to send emails on your behalf.
- Optional: Ability to edit the cron schedule if you want to change the daily run time.
Required Google Sheet Format
| Column | Description |
|---|---|
Profile_Name | The name of the commenter |
Profile_URL | A link to the commenter's social media profile |
The_Comment | The actual text of their comment |
How the Flow Works
| Step | Node | Description |
|---|---|---|
| 1 | Scheduled Trigger (Daily 8:30 AM IST) | Kickstarts the workflow every day automatically based on a cron schedule. |
| 2 | Google Sheets Fetch | Pulls the first 50 rows (including headers) from the specified social comments sheet. |
| 3 | AI Lead Analyst | Processes all comments in one batch to score intent levels, keeping only high-intent leads and generating email content. |
| 4 | Gmail Sender | Sends exactly one HTML email digest to your configured Gmail address summarizing the hot leads found. |
Output
At the end of each run, you receive a neatly formatted HTML email with:
- A bold summary line stating how many comments were scanned and how many high-intent leads were spotted.
- A numbered list of hot leads, with each lead's name in bold, their exact comment in italics, and a clickable blue link to their profile.
- If no hot leads are found, the email clearly indicates this.
Notes
- To change the data source, update the Google Sheet ID and range in the fetch node. You can find the sheet ID in your spreadsheet's URL between
/d/and/edit. - Modify the email recipient by updating the fixed "to" field in the Gmail send-email node.
- The AI scoring logic looks for phrases indicating buying interest (e.g., "send me the link", "interested", "DM me", "how to get") and ignores noise like generic compliments or emojis.
- Running this workflow once daily helps ensure you never miss timely lead follow-ups while minimizing email clutter.
- You can adjust the schedule by editing or replacing the cron expression in the scheduled trigger node. For example:
- Every 12 hours:
0 */12 * * * - Every Monday at 9 AM IST:
30 3 * * 1 - Manual only: Replace the scheduled trigger with a manual trigger node.
- Every 12 hours:
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.