Overview
Per-client Instagram content cron with live local context (events, weather, news) and brand fingerprint preservation. Sheets handoff for client approval.
Trigger
Weekly cron (or daily for high-volume clients)
Schedule
Weekly
Workflow Steps
1
Iterate active client list
Per-client config with brand fingerprint path + city/country.
2
Scavio: pull live local context
weather + events + recent news + reddit signal in target language.
3
Scavio: pull current promotional content from client website
site:client.com promotion 2026.
4
LLM compose: 7 captions w/ fingerprint + context
Output JSON list of {day, caption, hashtags, image_brief}.
5
Write to Google Sheet (one row per post, editable)
Add 'approved' column for client signoff.
6
Optional auto-publish post-approval
Buffer/Later or Meta Graph API on approved=TRUE.
Python Implementation
Python
import requests, os
H = {'x-api-key': os.environ['SCAVIO_API_KEY']}
def local_context(city, country, week):
queries = [f'weather {city} {week}', f'site:visit-{country}.com events', f'reddit r/{country} {city}']
out = []
for q in queries:
r = requests.post('https://api.scavio.dev/api/v1/search', headers=H, json={'query': q}).json()
out.extend(r.get('organic_results', [])[:3])
return outJavaScript Implementation
JavaScript
// n8n HTTP node = same shape.Platforms Used
Web search with knowledge graph, PAA, and AI overviews