Library / Social Media Publishing
Social Media Publishing
Compare Instagram posting rates with RecentReborn, Google Sheets and Telegram
Samples Instagram posting activity for configured venues and competitors on a schedule, logs the data to Sheets, and sends weekly comparison reports to Telegram.
What it does
## Compare Instagram posting rates at your venues and competitors with RecentReborn, Google Sheets and Telegram ### How it works This workflow tracks Instagram posting activity for configured venues and competitors by querying RecentReborn, storing samples and post details in Google Sheets, and sending Telegram updates. It supports an initial venue setup path through n8n forms, then runs on a schedule or manually to sample posting rates, append new data, update venue state, and produce weekly comparison reports. When enabled, it uses OpenAI to summarize caption themes before building the Telegram report. ### Setup steps - Configure the RecentReborn API access used by the HTTP Request nodes for location lookup and post search. - Connect Google Sheets credentials and prepare the target spreadsheet with the expected Venues, Samples, and Posts tabs/columns. - Create and connect a Telegram bot credential, then set the destination chat ID in the Set Venue Config node. - Update Set Venue Config with the spreadsheet URL, setup form URL, timezone, Telegram chat ID, and any quota or reporting settings used by the code nodes. - If AI summaries are desired, configure the OpenAI credential/model connected to the LLM Chain node; otherwise leave the AI summary setting disabled. ### Customization You can adjust the schedule frequency, request wait time, daily quota thresholds, report cadence, Telegram message wording, and whether weekly reports use AI caption summaries.
The steps
- When Venue Setup Form Submitted
- Every 4 Hours
- When Manually Triggered
- Set Venue Configuration
- If Venue Form Submitted
- Fetch Venue Locations
- Build Venue Selection Form
- If Venues Available
- Venue Selection Form
- Display Lookup Error
- Map Venue Selection to IDs
- Save Venues Data to Sheets
- Notify Venues Saved
- Read Venues Data from Sheets
49 steps in total.
Similar automations
Web Scraping & ResearchTrack competitor hotel rates with MrScraper, Gemini, Google Sheets and Telegram32 stepsMonitoring, Ops & IncidentsHourly Bitcoin and Ethereum Rates to Sheets and Telegram7 stepsFinance, Invoices & AccountingCheck foreign card charges against daily FX rates with Google Sheets and Slack16 stepsFinance, Invoices & AccountingUpdate Invoice Currency Rates in Google Sheets Daily7 steps