January 22, 2026

Google Sheets + OpenAI: faster Instagram vetting

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Instagram vetting usually starts simple. Then you’re juggling tabs, copying bios into notes, and trying to remember why “looks legit” felt true last Tuesday. That’s where Sheets OpenAI vetting automation earns its keep.

Influencer marketers feel it first. A community manager doing weekly partner checks gets hit too. And if you run a small agency, this is the kind of repetitive review work that quietly eats your margin.

This workflow watches your Google Sheet for new or updated Instagram handles, scrapes the public profile data, runs a two-pass OpenAI analysis, then writes clean, standardized insights back into the same row. You’ll see how it works, what you need, and where people trip up.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Google Sheets + OpenAI: faster Instagram vetting

Click to explore

flowchart LR

    subgraph sg0["Gatilho Linha Alterada Flow"]
        direction LR
        n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtop.svg' width='40' height='40' /></div><br/>Iniciar Sessão Airtop"]
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtop.svg' width='40' height='40' /></div><br/>Abrir Janela do Perfil"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtop.svg' width='40' height='40' /></div><br/>Extrair Dados do Perfil"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtop.svg' width='40' height='40' /></div><br/>Encerrar Sessão Airtop"]
        n4@{ icon: "mdi:robot", form: "rounded", label: "Parser Autoajuste A", pos: "b", h: 48 }
        n5@{ icon: "mdi:brain", form: "rounded", label: "Modelo Chat IA A", pos: "b", h: 48 }
        n6@{ icon: "mdi:robot", form: "rounded", label: "Parser Estruturado A", pos: "b", h: 48 }
        n7@{ icon: "mdi:robot", form: "rounded", label: "Parser Autoajuste B", pos: "b", h: 48 }
        n8@{ icon: "mdi:brain", form: "rounded", label: "Modelo Chat IA B", pos: "b", h: 48 }
        n9@{ icon: "mdi:robot", form: "rounded", label: "Parser Estruturado B", pos: "b", h: 48 }
        n10@{ icon: "mdi:robot", form: "rounded", label: "Formatar Saída do Perfil", pos: "b", h: 48 }
        n11@{ icon: "mdi:robot", form: "rounded", label: "Analisar Perfil com IA", pos: "b", h: 48 }
        n12@{ icon: "mdi:play-circle", form: "rounded", label: "Gatilho Linha Alterada", pos: "b", h: 48 }
        n13@{ icon: "mdi:swap-vertical", form: "rounded", label: "Processar Lotes", pos: "b", h: 48 }
        n14@{ icon: "mdi:database", form: "rounded", label: "Atualizar Registro Planilha", pos: "b", h: 48 }
        n15@{ icon: "mdi:cog", form: "rounded", label: "Retorno de Loop", pos: "b", h: 48 }
        n16@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filtrar Ativação Planilha", pos: "b", h: 48 }
        n15 --> n13
        n13 --> n0
        n3 --> n10
        n2 --> n3
        n0 --> n1
        n5 -.-> n4
        n5 -.-> n11
        n8 -.-> n7
        n8 -.-> n10
        n1 --> n2
        n12 --> n16
        n10 --> n11
        n6 -.-> n4
        n4 -.-> n11
        n9 -.-> n7
        n7 -.-> n10
        n11 --> n14
        n14 --> n15
        n16 --> n13
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n12 trigger
    class n4,n6,n7,n9,n10,n11 ai
    class n5,n8 aiModel
    class n16 decision
    class n14 database
    classDef customIcon fill:none,stroke:none
    class n0,n1,n2,n3 customIcon

The Problem: Instagram reviews don’t scale in a spreadsheet

If you review Instagram profiles manually, the process looks “quick” until you do it 30 times in a row. You open the profile, scan the bio, guess the niche, check recent posts, then paste bits into a Sheet (or worse, into a running doc). Small inconsistencies creep in fast. One reviewer writes a full paragraph, another writes “ok,” and a week later nobody trusts the notes because they’re stale, subjective, or missing key fields.

It adds up fast. Here’s where it breaks down once volume shows up.

Every profile review turns into 10+ minutes of tab-switching and copy-paste, which means a list of 50 handles can swallow most of a morning.
Notes aren’t standardized, so filtering for “brand-safe,” “high engagement,” or “UGC fit” becomes guesswork instead of an actual workflow.
Public profile data changes constantly, so yesterday’s “good candidate” can become “inactive” and no one notices until the campaign slips.
Manual reviews invite human error, especially when multiple teammates touch the same sheet and overwrite each other’s fields.

The Solution: Google Sheets → Airtop scraping → OpenAI insights → clean fields back in Sheets

This workflow turns your Google Sheet into a living queue for Instagram vetting. When a row is added or updated, n8n checks if that profile still needs analysis. If it does, the automation spins up an Airtop session, opens a fresh window to the Instagram profile, and scrapes the public data you’d normally eyeball (bio, visible metrics, and other public signals). Then OpenAI steps in twice: first to clean and structure the raw scrape into consistent fields, and second to generate deeper, decision-ready insights like likely niche, content style, brand safety notes, and recommended next steps. Finally, everything gets written back into the same row in Google Sheets so your team can sort, filter, and decide without hunting through screenshots or messy notes.

The workflow starts with a Google Sheets “row changed” trigger. Airtop handles the controlled browsing and scraping, then the AI agents refine and analyze the output. Google Sheets is the final destination, so your sheet stays the system of record.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

Detects new or updated Instagram handles in Google Sheets and queues them for review.
Scrapes public Instagram profile data through an Airtop session, without manual browsing.
Cleans and standardizes the scraped output into structured fields using OpenAI.
Runs a second AI pass to produce actionable vetting insights and updates the original row.

Most teams get about 5 hours back per week once volume hits 30–50 profiles.
Your sheet becomes filterable, because the fields are consistent instead of free-text chaos.
Fewer “we already reviewed this” mistakes, since the workflow checks if analysis is needed.
Reviews stay fresher, because reruns update the same record instead of creating new notes.
Faster yes/no decisions, since insights land where the work already happens: the spreadsheet.

Example: What This Looks Like

Say your team vets 40 Instagram profiles a week. Manually, assume about 10 minutes per profile to open the page, scan, and write notes, which is roughly 6–7 hours of attention-heavy work. With this workflow, you add handles to Google Sheets (maybe 5 minutes total for the whole batch), then wait for the scrape + AI processing to finish in the background. You still review the final notes, but you’re scanning standardized fields, so the “decision step” is closer to an hour than an entire morning.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for the handle list and results table.
Airtop to scrape public Instagram profile data.
OpenAI API key (get it from the OpenAI API dashboard).

Skill level: Intermediate. You’ll connect accounts, paste keys, and map sheet columns to the workflow’s fields.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A Google Sheets row changes. When a new Instagram handle is added (or an existing one is edited), the workflow triggers and checks a “needs analysis” condition so it doesn’t reprocess rows unnecessarily.

Items are processed in batches. If multiple rows change, n8n loops through them in a controlled way, which keeps the scraping and AI calls from piling up at once.

Airtop opens Instagram and scrapes public data. The workflow starts an Airtop session, opens a fresh window to the target profile, extracts the relevant public signals, then closes the session so you’re not leaving browser sessions hanging around.

OpenAI cleans, structures, then analyzes. First, the raw scrape is parsed into clean fields (think “data you can sort”). Then a second AI agent produces the judgement layer: niche, risks, opportunities, and what you should do next.

You can easily modify the “needs analysis” rule to re-check profiles weekly, or change the analysis prompts to match your brand safety policy and campaign goals. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Sheets Trigger

Start the workflow when a row is updated in your spreadsheet.

Add and configure Gatilho Linha Alterada.
Set Event to rowUpdate.
Select the Document ID and Sheet Name for your Instagram profile sheet (e.g., [TEMPLATE] - Instagram Profiles and gid=0).
Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.

⚠️ Common Pitfall: If the trigger sheet does not match the sheet used later in Atualizar Registro Planilha, updates won’t map correctly.

Step 2: Connect Google Sheets

Define how the workflow filters eligible rows and processes them in batches.

Configure Filtrar Ativação Planilha to only pass rows where Ativar Automação is true and Analisado is empty, using the expressions {{ $json['Ativar Automação'] }} and {{ $json.Analisado }}.
Connect Filtrar Ativação Planilha to Processar Lotes to enable batch processing.
Keep the loop by connecting Atualizar Registro Planilha to Retorno de Loop, and Retorno de Loop back to Processar Lotes.

Tip: Processar Lotes is a batch controller; it keeps the workflow iterating through rows that pass Filtrar Ativação Planilha.

Step 3: Configure Airtop Session and Extraction

Open the Instagram profile in Airtop, extract profile data, and close the session cleanly.

In Iniciar Sessão Airtop, set Profile Name to luis-testes-n8n and enable Save Profile On Termination.
Credential Required: Connect your airtopApi credentials in Iniciar Sessão Airtop.
In Abrir Janela do Perfil, set URL to =https://www.instagram.com/{{ $('Processar Lotes').item.json['@ - Instagram'] }}/ and Session ID to ={{ $('Iniciar Sessão Airtop').item.json.sessionId }}.
Credential Required: Connect your airtopApi credentials in Abrir Janela do Perfil, Extrair Dados do Perfil, and Encerrar Sessão Airtop.
In Extrair Dados do Perfil, keep the Prompt as provided to extract name, bio, followers, reels, stories, and first five posts.
Ensure Encerrar Sessão Airtop is connected after extraction to close the session with Operation set to terminate.

⚠️ Common Pitfall: If the Instagram handle column @ - Instagram is empty, Abrir Janela do Perfil will open an invalid URL.

Step 4: Set Up AI Formatting and Analysis

Use AI agents and output parsers to structure the profile data and generate an approval decision.

In Formatar Saída do Perfil, set Text to =Segue as informações do perfil para você tratar: {{ $('Extrair Dados do Perfil').item.json.data.modelResponse }} and keep Has Output Parser enabled.
Connect Modelo Chat IA B as the language model for Formatar Saída do Perfil. Credential Required: Connect your openAiApi credentials in Modelo Chat IA B.
Ensure Parser Estruturado B feeds into Parser Autoajuste B, which then connects as the output parser to Formatar Saída do Perfil. Add credentials to Modelo Chat IA B (not the parser nodes).
In Analisar Perfil com IA, use the provided analysis prompt and keep Has Output Parser enabled. The prompt references structured fields like {{ $json.output['Nome Perfil'] }} and {{ $json.output['Post 1'] }}.
Connect Modelo Chat IA A as the language model for Analisar Perfil com IA. Credential Required: Connect your openAiApi credentials in Modelo Chat IA A.
Ensure Parser Estruturado A feeds into Parser Autoajuste A, which then connects as the output parser to Analisar Perfil com IA. Add credentials to Modelo Chat IA A (not the parser nodes).

Tip: Keep the JSON schema examples in Parser Estruturado A and Parser Estruturado B unchanged to avoid output parsing errors.

Step 5: Configure Spreadsheet Updates

Write the AI analysis and profile data back into your Google Sheet.

Open Atualizar Registro Planilha and set Operation to update.
Set Matching Columns to @ - Instagram so updates match the correct row.
Map columns using the existing expressions, for example:
Set Bio to {{ $('Formatar Saída do Perfil').item.json.output.descricao }} and Informações to {{ $('Formatar Saída do Perfil').item.json.output['infos do perfil'] }}.
Set Análise IA to {{ $json.output.analise_completa }}, Aprovação IA to {{ $json.output.filtro }}, and Nota de Confiança to {{ $json.output.nota }}.
Set Analisado to Analisado em {{ $now.format('dd/MM/yyyy T') }} and Link do Perfil to =https://www.instagram.com/{{ $('Gatilho Linha Alterada').item.json['@ - Instagram'] }}/.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Atualizar Registro Planilha.

⚠️ Common Pitfall: If the column names in the sheet do not match the mapping keys (e.g., Aprovação IA, Nota de Confiança), the update will silently fail or write to the wrong fields.

Step 6: Test & Activate Your Workflow

Validate that the workflow processes a sample row and writes analysis results back to the sheet.

Manually update a row in the sheet to trigger Gatilho Linha Alterada, ensuring Ativar Automação is true and Analisado is empty.
Run the workflow once and confirm the execution path follows: Gatilho Linha Alterada → Filtrar Ativação Planilha → Processar Lotes → Iniciar Sessão Airtop → Abrir Janela do Perfil → Extrair Dados do Perfil → Encerrar Sessão Airtop → Formatar Saída do Perfil → Analisar Perfil com IA → Atualizar Registro Planilha → Retorno de Loop.
Check that the target row is updated with Bio, Informações, Aprovação IA, Nota de Confiança, and Análise IA.
Once verified, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n “Credentials” screen and confirm the connected Google account still has edit access to the sheet.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Frequently Asked Questions

How long does it take to set up this Sheets OpenAI vetting automation?

About an hour if your Sheet and API keys are ready.

Do I need coding skills to automate Instagram vetting?

No. You’ll mostly connect accounts and map your Google Sheets columns to the workflow fields.

Is n8n free to use for this Sheets OpenAI vetting workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few cents per profile) plus any Airtop usage beyond free credits.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this Sheets OpenAI vetting workflow for weekly re-checks instead of only new rows?

Yes, but you’ll change the trigger logic. Many teams add a scheduled trigger (weekly) and reuse the same “needs analysis” check by comparing a “last analyzed” date in Google Sheets. You can also tweak the “Analisar Perfil com IA” prompt to match your niche (fitness creators vs. SaaS founders feels very different). If you want cleaner output, adjust the structured parsers so the sheet columns stay consistent.

Why is my Airtop connection failing in this workflow?

Usually it’s expired Airtop credentials or a missing permission on the Airtop project you’re using. Re-authenticate Airtop in n8n, then confirm your Airtop credits are available and the session can be created. If it fails only on some profiles, it can be a page load issue; increase the batch pacing so Airtop has time to open the window and capture the content. Finally, check if Instagram is rate limiting or showing extra prompts, because that can break scraping until the session is restarted.

How many profiles can this Sheets OpenAI vetting automation handle?

On most setups, dozens per day is realistic, and self-hosting can push higher as long as your server and API limits keep up.

Is this Sheets OpenAI vetting automation better than using Zapier or Make?

It depends on what you call “better.” For scraping + multi-step AI parsing, n8n is usually easier to control because you can batch items, branch with conditions, and keep the logic in one place without paying per tiny step. Zapier and Make are great for simpler flows, but they can get awkward when you need a browser-style scraping tool (Airtop) plus two AI passes and structured parsing. Honestly, the deciding factor is volume: if you’ll vet lots of profiles, n8n tends to be more cost-stable. Talk to an automation expert if you want help choosing.

Once this is running, your spreadsheet stops being a dumping ground and becomes a real review system. The workflow handles the repetitive parts, so you can spend your time making the call.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": "",
"meta": {
"instanceId": "67164e9be40b0a4352446cfc973d931b6a64917a8d152e0e6822afde9b7c50fa",
"templateId": "",
"templateCredsSetupCompleted": null
},
"name": "Automated Instagram Profile Review",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-7481",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
65
],
"parameters": {
"color": 7,
"width": 1300,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "b6c19cd0-fc32-4d48-a126-ea9bd18d9e9a",
"name": "Iniciar Sess\u00e3o Airtop",
"type": "n8n-nodes-base.airtop",
"position": [
610,
235
],
"parameters": {
"profileName": "luis-testes-n8n",
"additionalFields": [],
"saveProfileOnTermination": true
},
"credentials": {
"airtopApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "92064a35-da79-46a4-bc3b-16f2f49c8da3",
"name": "Abrir Janela do Perfil",
"type": "n8n-nodes-base.airtop",
"position": [
820,
185
],
"parameters": {
"url": "=https://www.instagram.com/{{ $('Processar Lotes').item.json['@ - Instagram'] }}/",
"resource": "window",
"sessionId": "={{ $('Iniciar Sess\u00e3o Airtop').item.json.sessionId }}",
"additionalFields": []
},
"credentials": {
"airtopApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "7252cd11-d797-4f74-b7f3-1a953e4e7f22",
"name": "Extrair Dados do Perfil",
"type": "n8n-nodes-base.airtop",
"position": [
1010,
245
],
"parameters": {
"prompt": "=This is an Instagram profile page. Extract the following data:\n\n- Name: Extract the full name of the profile owner.\n- Description: Provide the profile description or bio.\n- Number of Publications: Extract the total number of publications\n- Followers: Extract the total number of followers.\n- Followed: Extract the total number of accounts followed by this profile.\n- Reels: Provide a link to the Reels section of the profile.\n- Stories: list all the stories, with its information, in the profile\n- First Five Publications: Extract details of the first five posts, including:\n  - Image or video description\n  - Date of publication\n  - Number of likes and comments if available\n  - Any hashtags or mentions included in the post",
"resource": "extraction",
"operation": "query",
"additionalFields": []
},
"credentials": {
"airtopApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "f944eeb7-70e7-49a3-a690-083e84bea4da",
"name": "Encerrar Sess\u00e3o Airtop",
"type": "n8n-nodes-base.airtop",
"position": [
1180,
195
],
"parameters": {
"operation": "terminate"
},
"credentials": {
"airtopApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "e8e2ebb2-ae6b-49cc-939c-935e6f31af20",
"name": "Parser Autoajuste A",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
1060,
590
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "5a6c6850-fbd7-475b-b6c7-ae64da13ccb1",
"name": "Modelo Chat IA A",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
760,
625
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "20142349-a1a9-4666-aa88-f6e30eca8969",
"name": "Parser Estruturado A",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
900,
640
],
"parameters": {
"jsonSchemaExample": "{\n  \"filtro\": \"Aprovado ou Reprovado\",\n  \"nota\": \"de 0 a 10\",\n  \"analise_completa\":\"aqui a analise detalhada\"\n}"
},
"typeVersion": 1.2
},
{
"id": "c1c7209d-7c56-4897-848d-476f6d1bd126",
"name": "Parser Autoajuste B",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
1120,
610
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "e5067772-07fd-4dfc-8f92-78c105a515ce",
"name": "Modelo Chat IA B",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1200,
665
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "gpt-4o-mini"
},
"options": []
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.2
},
{
"id": "c8ddfd1e-e0ed-4f6a-805f-26bdc74b9778",
"name": "Parser Estruturado B",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
960,
630
],
"parameters": {
"jsonSchemaExample": "{\n  \"Nome Perfil\": \"Nome\",\n  \"descricao\": \"Descri\u00e7\u00e3o\",\n  \"infos do perfil\": \"Informa\u00e7\u00f5es do perfil\",\n  \"Destaques\": \"Stories\",\n  \"Post 1\": \"Descri\u00e7\u00e3o\",\n  \"Post 2\": \"Descri\u00e7\u00e3o\",\n  \"Post 3\": \"Descri\u00e7\u00e3o\",\n  \"Post 4\": \"Descri\u00e7\u00e3o\",\n  \"Post 5\": \"Descri\u00e7\u00e3o\"\n}\n"
},
"typeVersion": 1.2
},
{
"id": "b53d96a9-b9cd-447b-8fea-fc39c6f31feb",
"name": "Formatar Sa\u00edda do Perfil",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1030,
425
],
"parameters": {
"text": "=Segue as informa\u00e7\u00f5es do perfil para voc\u00ea tratar:\n\n{{ $('Extrair Dados do Perfil').item.json.data.modelResponse }}",
"options": {
"systemMessage": "=## Objetivo:\n\nSua fun\u00e7\u00e3o \u00e9 pegar o texto recebido e fazer a separa\u00e7\u00e3o dos conte\u00fados no modelo de Output Parser.\n\n## Estrutura:\nSepare as informa\u00e7\u00f5es em:\n  - Nome do Perfil: Nome\n  - Descri\u00e7\u00e3o do Perfil: Descri\u00e7\u00e3o\n  - Informa\u00e7\u00f5es do Perfil: N\u00famero de Publica\u00e7\u00f5es, Seguidores, Seguidos\n  - Destaques: Stories\n  - Post 1\n    - Descri\u00e7\u00e3o\n  - Post 2\n    - Descri\u00e7\u00e3o\n  - Post 3\n    - Descri\u00e7\u00e3o\n  - Post 4\n    - Descri\u00e7\u00e3o\n  - Post 5\n    - Descri\u00e7\u00e3o\n\n\n## Formato de resposta:\n\n(JSON)\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "f9051045-3176-4545-b9a9-2d78708646f9",
"name": "Analisar Perfil com IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
830,
445
],
"parameters": {
"text": "=Segue as informa\u00e7\u00f5es que foram encontradas do Perfil para sua an\u00e1lise.\n\nNome do Perfil: {{ $json.output['Nome Perfil'] }}\nDescri\u00e7\u00e3o/ Bio do Perfil: {{ $json.output.descricao }}\nInforma\u00e7\u00f5es do Perfil: {{ $json.output['infos do perfil'] }}\nDestaques: {{ $json.output.Destaques }}\n\nPost 1 - Descri\u00e7\u00e3o: {{ $json.output['Post 1'] }}\n---\nPost 2 - Descri\u00e7\u00e3o: {{ $json.output['Post 2'] }}\n---\nPost 3 - Descri\u00e7\u00e3o: {{ $json.output['Post 3'] }}\n---\nPost 4 - Descri\u00e7\u00e3o: {{ $json.output['Post 4'] }}\n---\nPost 5 - Descri\u00e7\u00e3o: {{ $json.output['Post 5'] }}\n",
"options": {
"systemMessage": "=## Persona:\nVoc\u00ea \u00e9 um agente de IA especialista em fazer an\u00e1lise de Perfis no Instagram.\n\n## Fun\u00e7\u00e3o:\nA sua fun\u00e7\u00e3o \u00e9 analisar informa\u00e7\u00f5es e dados de perfis de Instagram de empres\u00e1rios e empreendedores. \n\n## Objetivo:\nO seu objetivo \u00e9 diagnosticar se o perfil do Instagram \u00e9 ideal para fazer parte de um grupo de empreendedores digitais de alto n\u00edvel, ent\u00e3o o perfil precisa apresentar sinais de faturamento expressivo.\n\n## Comportamento:\nPara chegar no seu objetivo analise:  \n\n1- Identificar se \u00e9 do nicho de Marketing Digital, pois \u00e9 o \u00fanico nicho que queremos que seja analisado. O restante que n\u00e3o for de Marketing Digital pode reprovar.\n2- informa\u00e7\u00f5es do perfil que indique \"resultado\" (participa\u00e7\u00e3o em mastersminds/eventos, placas de premia\u00e7\u00e3o, prints, seguidores)  \n3- identificar se essa pessoa n\u00e3o mexe com algo errado/il\u00edcito (Casas de Apostas, Produtos de Nicho Black, Pol\u00edtica, etc.) \n4- Analise se as informa\u00e7\u00f5es do perfil, se condizem com o que foi dito na bio/ descri\u00e7\u00e3o do perfil. \n5- Caso exista alguma evid\u00eancia onde indica que o perfil fatura menos de 1 milh\u00e3o de reais por ano, reprove.\n\n## Importante:\nN\u00e3o \u00e9 preciso ter uma comprova\u00e7\u00e3o clara de resultados que sejam acima de 1 milh\u00e3o de reais/ano. Use o n\u00famero de 1 milh\u00e3o de reais apenas caso exista uma comprova\u00e7\u00e3o clara desse resultado.\n\n- Resumindo: N\u00e3o ter a certeza de que o perfil fatura acima de 1 milh\u00e3o de reais/ano n\u00e3o o elimina, o que elimina \u00e9 a certeza de que ele fatura menos\n\nQuando for me responder, tamb\u00e9m quero que me d\u00ea:  \n- Uma decis\u00e3o: aprovado ou reprovado  \n- Uma nota de confian\u00e7a (0 a 10)  \n- Uma sugest\u00e3o de assunto para puxar papo no direct (caso seja aprovado)\n\n- Caso \u00e3ao tenha dados dos posts devido o seu perfil ser privado, traga i\u00e1o na analise. Exemplo de texto na an\u00e1lise: Descri\u00e7\u00e3o: Informa\u00e7\u00f5es de posts n\u00e3o dispon\u00edveis devido ao perfil ser privado.\"\n\n## Formato da resposta:\n(JSON)\n{\n  \"filtro\": \"Aprovado ou Reprovado\",\n  \"nota\": \"de 0 a 10\",\n  \"sugestao_papo\": \"sugest\u00e3o de assunto para puxar papo no direct (caso seja aprovado)\n  \"analise_completa\":\"aqui a an\u00e1lise detalhada\"\n}"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "56a6e5e0-13b7-4214-bb39-bfca9dbf41c0",
"name": "Gatilho Linha Alterada",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
0,
170
],
"parameters": {
"event": "rowUpdate",
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "P\u00e1gina1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "[TEMPLATE] - Instagram Profiles"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "8c0ce121-888e-4fd9-bebb-6d0c3dbfe667",
"name": "Processar Lotes",
"type": "n8n-nodes-base.splitInBatches",
"position": [
420,
165
],
"parameters": {
"options": []
},
"typeVersion": 3
},
{
"id": "7c434303-2b67-4090-a1cd-497297b4402f",
"name": "Atualizar Registro Planilha",
"type": "n8n-nodes-base.googleSheets",
"position": [
620,
415
],
"parameters": {
"columns": {
"value": {
"Bio": "={{ $('Formatar Sa\u00edda do Perfil').item.json.output.descricao }}",
"Nome": "{{ $('Processar Lotes').item.json['@ - Instagram'] }}",
"Analisado": "=Analisado em {{ $now.format('dd/MM/yyyy T') }}",
"An\u00e1lise IA": "={{ $json.output.analise_completa }}",
"@ - Instagram": "={{ $('Processar Lotes').item.json['@ - Instagram'] }}",
"Informa\u00e7\u00f5es": "={{ $('Formatar Sa\u00edda do Perfil').item.json.output['infos do perfil'] }}",
"Aprova\u00e7\u00e3o IA": "={{ $json.output.filtro }}",
"Link do Perfil": "=https://www.instagram.com/{{ $('Gatilho Linha Alterada').item.json['@ - Instagram'] }}/",
"Nota de Confian\u00e7a": "={{ $json.output.nota }}"
},
"schema": [
{
"id": "Ativar Automa\u00e7\u00e3o",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Ativar Automa\u00e7\u00e3o",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "@ - Instagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "@ - Instagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Nome",
"type": "string",
"display": true,
"required": false,
"displayName": "Nome",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Bio",
"type": "string",
"display": true,
"required": false,
"displayName": "Bio",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Informa\u00e7\u00f5es",
"type": "string",
"display": true,
"required": false,
"displayName": "Informa\u00e7\u00f5es",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Aprova\u00e7\u00e3o Humana",
"type": "string",
"display": true,
"required": false,
"displayName": "Aprova\u00e7\u00e3o Humana",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Aprova\u00e7\u00e3o IA",
"type": "string",
"display": true,
"required": false,
"displayName": "Aprova\u00e7\u00e3o IA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Nota de Confian\u00e7a",
"type": "string",
"display": true,
"required": false,
"displayName": "Nota de Confian\u00e7a",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "An\u00e1lise IA",
"type": "string",
"display": true,
"required": false,
"displayName": "An\u00e1lise IA",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Analisado",
"type": "string",
"display": true,
"required": false,
"displayName": "Analisado",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link do Perfil",
"type": "string",
"display": true,
"required": false,
"displayName": "Link do Perfil",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"@ - Instagram"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit#gid=0",
"cachedResultName": "Profiles"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_ID]/edit",
"cachedResultName": "[TEMPLATE] - Instagram Profiles"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.6
},
{
"id": "6813d4d6-1470-4662-a3f7-b36d0ef82256",
"name": "Retorno de Loop",
"type": "n8n-nodes-base.noOp",
"position": [
420,
465
],
"parameters": [],
"typeVersion": 1
},
{
"id": "0e0d5f1d-c880-4ffb-bc01-b14ddec40179",
"name": "Filtrar Ativa\u00e7\u00e3o Planilha",
"type": "n8n-nodes-base.filter",
"position": [
210,
205
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "20034d81-bf44-45e0-a29c-8b113c2383e4",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json['Ativar Automa\u00e7\u00e3o'] }}",
"rightValue": "Aprovado"
},
{
"id": "8b3d201f-cf1e-43d7-9d99-a13b3a769b82",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Analisado }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"Retorno de Loop": {
"main": [
[
{
"node": "Processar Lotes",
"type": "main",
"index": 0
}
]
]
},
"Processar Lotes": {
"main": [
[],
[
{
"node": "Iniciar Sess\u00e3o Airtop",
"type": "main",
"index": 0
}
]
]
},
"Encerrar Sess\u00e3o Airtop": {
"main": [
[
{
"node": "Formatar Sa\u00edda do Perfil",
"type": "main",
"index": 0
}
]
]
},
"Extrair Dados do Perfil": {
"main": [
[
{
"node": "Encerrar Sess\u00e3o Airtop",
"type": "main",
"index": 0
}
]
]
},
"Iniciar Sess\u00e3o Airtop": {
"main": [
[
{
"node": "Abrir Janela do Perfil",
"type": "main",
"index": 0
}
]
]
},
"Modelo Chat IA A": {
"ai_languageModel": [
[
{
"node": "Parser Autoajuste A",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Analisar Perfil com IA",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Modelo Chat IA B": {
"ai_languageModel": [
[
{
"node": "Parser Autoajuste B",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Formatar Sa\u00edda do Perfil",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Abrir Janela do Perfil": {
"main": [
[
{
"node": "Extrair Dados do Perfil",
"type": "main",
"index": 0
}
]
]
},
"Gatilho Linha Alterada": {
"main": [
[
{
"node": "Filtrar Ativa\u00e7\u00e3o Planilha",
"type": "main",
"index": 0
}
]
]
},
"Formatar Sa\u00edda do Perfil": {
"main": [
[
{
"node": "Analisar Perfil com IA",
"type": "main",
"index": 0
}
]
]
},
"Parser Estruturado A": {
"ai_outputParser": [
[
{
"node": "Parser Autoajuste A",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Parser Autoajuste A": {
"ai_outputParser": [
[
{
"node": "Analisar Perfil com IA",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Parser Estruturado B": {
"ai_outputParser": [
[
{
"node": "Parser Autoajuste B",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Parser Autoajuste B": {
"ai_outputParser": [
[
{
"node": "Formatar Sa\u00edda do Perfil",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Analisar Perfil com IA": {
"main": [
[
{
"node": "Atualizar Registro Planilha",
"type": "main",
"index": 0
}
]
]
},
"Atualizar Registro Planilha": {
"main": [
[
{
"node": "Retorno de Loop",
"type": "main",
"index": 0
}
]
]
},
"Filtrar Ativa\u00e7\u00e3o Planilha": {
"main": [
[
{
"node": "Processar Lotes",
"type": "main",
"index": 0
}
]
]
}
}
}