Calvin Cunningham
AI Agency founder helping SMB's implement AI systems to generate revenue and save time. Check out my website to book a FREE consultation! https://mannaconsulting.ai
Templates by Calvin Cunningham
Expense Logging with Telegram to Google Sheets using AI Voice & Text Parsing
Use Cases -Personal or family budget tracking. -Small business expense logging via Telegram -Hands-free logging (using voice messages) --- How it works: -Trigger receives text or voice. -Optional branch transcribes audio to text. -AI parses into a structured array (SOP enforces schema). -Split Out produces 1 item per expense. -Loop Over Items appends rows sequentially with a Wait, preventing missed writes. -In parallel, Item Lists (Aggregate) builds a single summary string; Merge (Wait for Both) releases one final Telegram confirmation. ---- Setup Instructions Connect credentials: Telegram, Google, OpenAI. Sheets: Create a sheet with headers Date, Category, Merchant, Amount, Note. Copy Spreadsheet ID + sheet name. Map columns in Append to Google Sheet. Pick models: set Chat model (e.g., gpt-4o-mini) and Whisper for transcription if using audio. Wait time: keep 500–1000 ms to avoid API race conditions. Run: Send a Telegram message like: Gas 34.67, Groceries 82.45, Coffee 6.25, Lunch 14.90. ---- Customization ideas: -Add categories map (Memory/Set) for consistent labeling. -Add currency detection/formatting. -Add error-to-Telegram path for invalid schema.
By Calvin CunninghamEmail Verification and Enrichment from Google Sheets with Hunter and Dropcontact
Description This workflow automatically validates email addresses stored in a Google Sheet using Hunter Email Verifier, enriches the valid ones with Dropcontact, updates the sheet with verification and enrichment results, and sends a Slack summary showing total emails checked, valid emails, and enriched profiles. It helps teams clean their data, improve outreach accuracy, and eliminate the manual effort of checking and researching email contacts one by one. How It Works The workflow triggers whenever a new row is added or updated in your Google Sheet. It reads any emails that still need to be processed. Each email is validated using Hunter Email Verifier, which returns validity and a confidence score. Emails marked as valid and above the confidence threshold are enriched with Dropcontact to gather additional profile information, including: Full name Job title Company Domain Country Invalid or low-confidence emails are marked as invalid and skipped. Verification and enrichment results are written back into the corresponding row in your Google Sheet. A Slack summary message is sent showing: Total emails processed Number of valid emails Number of enriched profiles Credential Requirements Hunter Email Verifier: Required for the email validation step. Dropcontact: Requires a business email address (non-Gmail, non-Outlook, non-Yahoo) to create an account and use their API. Google Sheets: Required for reading and updating your contact list. Slack: Required to send the summary notification. Why This Is Helpful Automates a repetitive and error-prone workflow. Saves Dropcontact credits by enriching only valid, high-quality emails. Improves data accuracy for outreach, lead generation, and CRM imports. Keeps your Google Sheet updated with clean, structured verification and enrichment results. Sends a summary to Slack so your team gets instant visibility without opening the sheet. Ideal for teams preparing outbound lists, cleaning CRM data, or verifying large batches of emails before campaigns. Customization Ideas Add a second enrichment provider (such as Clearbit or People Data Labs) to fill in missing fields when Dropcontact does not return enough data. Send enriched contacts to a CRM, such as HubSpot, Airtable, Pipedrive, or Notion, instead of keeping everything in Google Sheets. Create separate Slack channels for valid vs. invalid contacts to help teams prioritize follow-up. Add quality tiers by creating categories such as "High Confidence," "Medium Confidence," and "Low Confidence" based on the verification score. Auto-tag enriched leads with fields like industry, employee count, or revenue if you integrate additional enrichment sources. Trigger this workflow nightly using a Schedule node if you want to process batches instead of reacting to row updates. Automatically send outreach emails to enriched leads using Gmail, Outlook, or Resend, after adding a safety check or approval step. Export enriched contacts to CSV or Google Drive for easy sharing with other teams. Add duplicate detection logic to avoid enriching the same contact multiple times. Add a notification for “no enrichments found” so your team knows when Dropcontact fails to return details.
By Calvin Cunningham