Tutorials / CSV Data

Sellerboard & CSVs

Learn how to automatically bridge passive CSV data directly into GFAVIP Webhooks.

What is a Bridge?

A Bridge is an automated workflow that connects a static CSV link (like a Sellerboard Daily Report) to a GFAVIP or Webchat webhook.

Instead of manually downloading a CSV, calculating the totals, and typing them into a chat or dashboard, VACN runs on a schedule to do the downloading, math, and posting for you automatically.

Creating Your First Bridge

1

Configure the Trigger (CSV Source)

Provide the direct URL to your CSV file. This URL must return a downloadable CSV file when accessed. Then, select how often you want VACN to fetch this file (e.g., Hourly, Daily at 08:00).

Example URL: https://example.com/reports/daily_sales.csv
2

Set up the Parser (Data & Math)

Tell VACN which columns to extract from your CSV. We will automatically sum all the rows for the columns you list.

If you want to perform custom math (like calculating profit margins), you can provide a JSON object where the keys are your new variables and the values are math formulas. Use lowercase column names with underscores instead of spaces.

Columns to Extract:

Total Sales, Total Costs

Math Expression (JSON):

{"profit": "total_sales - total_costs"}
3

Define the Action (Webhook)

Paste the destination Webhook URL (from GFAVIP or Webchat). You can use our Auto-Generate Payload button to build a beautiful template, or write your own JSON payload. You can inject your variables using double curly braces . Because the chat supports Markdown, you can use **bold** text and standard [text](url) links!

JSON Payload Template:

{
  "title": "Daily Sales Report",
  "message": "**Sales:** $\n**Profit:** $\n\nšŸ‘‰ [View Report]()",
  "color": "#1d4ed8"
}
                                    
4

The Full Data Report

Every time a Bridge runs, VACN extracts all the rows from your CSV and generates a beautiful, interactive data table. We automatically generate a special variable called {{report_url}} that you can add to the bottom of your webchat messages.

When your team clicks that link in the chat, they will be taken to a secure, sortable, filterable table on VACN containing all the granular details (like individual SKUs, stock levels, or sales breakdowns) for that specific run!

Understanding Teams

When you first log in, a Personal team is automatically created for you. Any bridges assigned to "Personal" are private and only visible to you.

If you are on a Premium or Team tier, you can create new Teams (like "Marketing Team") and assign bridges to them. Any member of that team will be able to view, edit, and manually run those shared bridges.