Scraping & Researchfree

Automated Brand Mentions Tracker with GPT 4o, Google Sheets, and Email

by Daniel ShashkoUpdated Aug 2026

Requires

Google Sheets

Email (SMTP)

1/5

STEPS · 6

Runs on a schedule

On a schedule, fetches brand mentions through an API, records them in Google Sheets, and emails a summary digest.

Competitor Launch Calendar

On a schedule, pulls competitor ad data from Adyntel and updates a launch calendar in Google Sheets.

On form submission, records trip feedback in Google Sheets and sends follow-up emails via SMTP.

On a schedule, fetches Crunchbase investor data via HTTP, transforms it with code, and appends rows to Google Sheets.