{"product_id":"instagram-venue-vs-competitor-benchmarking-n8n-workflow","title":"Instagram Venue vs Competitor Benchmarking n8n Workflow","description":"\u003ch3\u003eBenchmark Instagram posting activity for your venues vs competitors—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow benchmarks Instagram posting behavior for your venues against competitors using \u003cstrong\u003eRecentReborn\u003c\/strong\u003e. It stores samples and newly detected posts in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and delivers \u003cstrong\u003eweekly ranked reports\u003c\/strong\u003e plus \u003cstrong\u003eTelegram alerts\u003c\/strong\u003e—with an optional \u003cstrong\u003eOpenAI\u003c\/strong\u003e caption summary.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives venue submissions\u003c\/strong\u003e via an n8n form submission (or runs on a \u003cem\u003e4-hour schedule\u003c\/em\u003e \/ manual test), then loads shared configuration values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup mode:\u003c\/strong\u003e searches RecentReborn for matching Instagram locations, lets you select the correct \u003cstrong\u003elocation IDs\u003c\/strong\u003e, and saves each entry to the \u003cstrong\u003eVenues\u003c\/strong\u003e tab as either \u003cem\u003eown venue\u003c\/em\u003e or \u003cem\u003ecompetitor\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled\/manual benchmarking runs:\u003c\/strong\u003e reads active venues from the Venues sheet, caps the run size, and sends a \u003cstrong\u003eTelegram reminder\u003c\/strong\u003e if no venues are configured.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches newest posts per venue\u003c\/strong\u003e from RecentReborn (respecting delays and quota limits) and \u003cstrong\u003ecalculates an estimated posting rate\u003c\/strong\u003e using post timestamps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e: appends per-venue samples and any newly seen posts to \u003cstrong\u003eSamples\u003c\/strong\u003e and \u003cstrong\u003ePosts\u003c\/strong\u003e, then updates each venue’s watermark and last status in \u003cstrong\u003eVenues\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly reporting:\u003c\/strong\u003e when the report window is due, aggregates the last \u003cem\u003eN\u003c\/em\u003e days of Samples\/Posts, optionally summarizes captions with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, and sends a \u003cstrong\u003eranked report\u003c\/strong\u003e and alerts to \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack how often your venues post on Instagram versus key competitors.\u003c\/li\u003e\n  \u003cli\u003eMaintain an always-current benchmark using automated RecentReborn data ingestion.\u003c\/li\u003e\n  \u003cli\u003eGenerate weekly performance insights for SaaS operations or agency client reporting.\u003c\/li\u003e\n  \u003cli\u003eAlert your team when posting activity patterns change week over week.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecentReborn\u003c\/strong\u003e API credential using \u003cstrong\u003eHTTP Header Auth\u003c\/strong\u003e with \u003ccode\u003eAuthorization: Bearer \u0026lt;key\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with \u003cstrong\u003eVenues\u003c\/strong\u003e, \u003cstrong\u003eSamples\u003c\/strong\u003e, and \u003cstrong\u003ePosts\u003c\/strong\u003e tabs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e notifications for reminders, alerts, and weekly reports.\u003c\/li\u003e\n  \u003cli\u003eOptional \u003cstrong\u003eOpenAI\u003c\/strong\u003e caption summarization.\u003c\/li\u003e\n  \u003cli\u003eImplemented with n8n nodes such as \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eform\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and \u003cstrong\u003esplit out\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46223949037747,"sku":"N8N-20901","price":58.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/WJ3rbN5DNV4WE2WfXiwD6_YB1TQKEx.png?v=1791969530","url":"https:\/\/buyflowscripts.com\/products\/instagram-venue-vs-competitor-benchmarking-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}