- AI-Agent
- Ready to Run
Import Activity CSVs
Validate rows and load website activity into your analysis table
Use this Agent instantly or customize it - no programming needed
- Folder change noticeFolder change notice
Your folder sends this notice when a new file appears, so the Agent can find the export.
- website activity CSV fileswebsite activity CSV files
Your website activity CSV files supply the rows and source row numbers for validation.
- Import settingsImport settings
Your choices set the row checks, destination table, and analyst email.
Your file sharing service finds new exports, downloads them, and shares import reports by email.
- Import reportImport report
Your report counts source, inserted, and rejected rows and explains each rejection.
- Analyst notificationAnalyst notification
Your analyst gets the import tally and a report link in a file sharing email.
- Activity rowsActivity rows
Your analysis table receives valid rows, while rows it rejects appear in the report.
Your analysis database stores accepted activity rows and returns errors for rows it cannot insert.
- Import reportImport report
Your report counts source, inserted, and rejected rows and explains each rejection.
- Analyst notificationAnalyst notification
Your analyst gets the import tally and a report link in a file sharing email.
- Import reportImport report
Your report counts source, inserted, and rejected rows and explains each rejection.
- Analyst notificationAnalyst notification
Your analyst gets the import tally and a report link in a file sharing email.
This Agent spots a new website activity CSV in your export folder. It checks rows and imports valid activity into your analysis table. You get an import tally and a report of rejected rows.
Modify Agent
Customize this Agent to fit your needs using natural language.
Start Agent for Free
Enter your email address and we will send you a secure link to continue.
AirtableUsed as:
- Analysis database
Airtable stores accepted activity rows and returns errors for rows it cannot insert.
ZoomUsed as:
- File sharing service
Zoom finds new exports, downloads them, and shares import reports by email.
Microsoft SharePointUsed as:
- File sharing service
Microsoft SharePoint finds new exports, downloads them, and shares import reports by email.
- Analysis database
Microsoft SharePoint stores accepted activity rows and returns errors for rows it cannot insert.
Microsoft Office 365Used as:
- File sharing service
Microsoft Office 365 finds new exports, downloads them, and shares import reports by email.
Google BigQueryUsed as:
- Analysis database
Google BigQuery stores accepted activity rows and returns errors for rows it cannot insert.
MySQLUsed as:
- Analysis database
MySQL stores accepted activity rows and returns errors for rows it cannot insert.
KintoneUsed as:
- Analysis database
Kintone stores accepted activity rows and returns errors for rows it cannot insert.
Made for your industry
Import Activity CSVs is made for businesses in these industries.
- Advertising and Marketing
Import checked website activity for client campaign analysis.
Show all Agents for the Advertising and Marketing industry - Digital Media
Load clean site activity for audience analysis.
Show all Agents for the Digital Media industry - News Media
Check website activity exports for readership analysis.
Show all Agents for the News Media industry
Made for your role
Import Activity CSVs is made for people in these roles.
- Marketing Analyst
Keep website activity usable for campaign reporting.
Show all Agents for the Marketing Analyst role - Data Analyst
Load valid activity rows and flag rejects for analysis.
Show all Agents for the Data Analyst role - Reporting Analyst
Import clean website activity for reporting.
Show all Agents for the Reporting Analyst role - Data Operations Manager
Reconcile each import and surface rejected activity rows.
Show all Agents for the Data Operations Manager role - Data Coordinator
Check incoming activity files and report rejected rows.
Show all Agents for the Data Coordinator role - Data Engineer
Validate export rows before adding them to the analysis table.
Show all Agents for the Data Engineer role
Made for your department
Import Activity CSVs is made for people in these departments.
- Marketing
Prepare clean site activity for campaign analysis.
Show all Agents for the Marketing department - Data Analytics
Load valid website activity for analysis and flag rejects.
Show all Agents for the Data Analytics department - Business Intelligence
Import checked site activity into a queryable table.
Show all Agents for the Business Intelligence department - Data Operations
Check export rows before loading them into the analysis table.
Show all Agents for the Data Operations department
How Import Activity CSVs works
5 steps, in order, on every run.
-
Find the new CSVFind a new CSV in the folder you choose and read its activity rows. Skip files outside that folder.
-
Check activity rowsCheck dates, identifiers, and required fields against your rules. Record the row number and reason for every rejection.
-
Import valid rowsInsert valid rows into your analysis table in batches. Add any rows the table rejects to the exception report.
-
Reconcile the importCount inserted and rejected rows against the source file. Prepare a report with each rejected row's number and reason.
-
Send the tallySave the report beside the CSV. Send the analyst an email with the counts and a link to the report.
How to Get Started
Connect the tools you already use, such as Airtable, Zoom or Microsoft SharePoint.
7 tools
- Choose the folder where completed website activity CSV exports are placed and the analyst's email address.
- Choose the destination analysis table and map the export columns to its columns, including the event date and stable event identifier.
- Set the required columns, valid date range and format, and identifier rules for an acceptable activity row.
Use safe mode to approve every result before it goes out, or let the Agent run automatically.
FAQs
Frequently asked questions about the Import Activity CSVs:
Choose your export folder, analysis table, and email address. Map the CSV columns and set rules for dates, identifiers, and required fields.
Yes, when your CSV contains row-level activity with the IDs, dates, and fields you require. Choose a matching BigQuery table and map its columns.
You get row numbers and reasons for rejected rows. If the file will not open or lacks required headers, the Agent imports no rows and names the problem.
It stops and asks you. The Agent does not guess when it reaches a decision you have not approved.
Yes. Every run creates a plain-language log that you can review and export. Logs are kept for twelve months.
The Agent stops at the end of the billing month and its tool connections are removed. Your run logs remain available for twelve months.
Agents related to Import Activity CSVs
More ready-to-run Agents for connected work.
Your coordinator gets both revision links in chat when the task and current proof differ, with the task held for a human choice.
17 toolsYour bill review stays on hold when a supplier sends a corrected invoice, with both versions and the earlier decision linked for your reviewer.
6 toolsYour campaign card shows whether the assigned reviewer can open the linked file, so your team can fix sharing before requesting review.
7 toolsYour review task shows file access problems before review starts. The owner sees what to fix.
6 tools