Monitor Instagram location posts and build creator leads in Google Sheets with Telegram alerts

Description

Quick overview This workflow lets you pick Instagram locations via an n8n form, then every 30 minutes searches those locations through RecentReborn, logs new posts to Google Sheets, builds/upserts a creator lead list, and sends Telegram alerts for high-engagement posts, new regular creators, digests, and errors. How it works Receives a location search term through an n8n Form trigger, looks up matching Instagram locations in RecentReborn, and lets you select which locations to monitor. Saves the selected location IDs and names to the Google Sheets “Locations” tab without overwriting existing per-location monitoring state. Runs every 30 minutes (or on manual execution), reads active locations and existing creators from Google Sheets, and sends a Telegram reminder if no active locations are configured. For each active location, queries RecentReborn for recent location posts (up to three pages) and stops paging when posts are older than the stored cutoff time. Deduplicates and filters results, appends newly discovered posts to the Google Sheets “Posts” tab, and upserts qualifying accounts into the “Creators” tab while preserving any existing “Outreach Status” edits. Updates each location’s monitoring state in the Google Sheets “Locations” tab (watermark, recent post IDs, and run status) so the next run continues from the right point. Sends Telegram messages for viral posts, creators who become “regulars,” an optional per-run digest, and combined warnings for any location searches or sheet writes that fail. Setup Create a RecentReborn account and add an HTTP Header Auth credential with header name Authorization and value Bearer YOUR_KEY for the RecentReborn HTTP requests. Create a Google Sheet with “Locations”, “Posts”, and “Creators” tabs, then connect your Google Sheets OAuth2 credential and set the sheet URL in the workflow configuration. Create a Telegram bot, connect your Telegram credential, and set the target Telegram chat ID in the workflow configuration. Publish the “Location Setup Form” and paste its production URL into setupFormUrl, then adjust thresholds (formats, like limits, regular threshold, digest) in the configuration before activating. Requirements A RecentReborn API account (app.recentreborn.com) with an API key. An n8n automation workflow template by Felix M.

Community Metrics

Categories

• Automation

Tags

• n8n
• workflow
• google-sheets
• http-request
• telegram
• code

Capabilities

• 4 nodes

Information