Create CSV files, export reports, email requested data. Every one is ready to run, and you can adjust it in plain language.
Export requested data tabs as CSV files for other systems.
Your coworkers get the Google Sheets tab they asked for as a CSV attachment, or a reply explaining what needs fixing.
Update tracked spreadsheet fields and flag missing source values.
Your shared sheet stays current with daily JSON records. Your email shows new and changed row counts and links to entries needing attention.
Reconcile API records by ID and export a current analysis table.
Your shared spreadsheet stays current with the latest JSON feed. Get a matching CSV and a report of what changed.
Prepare API response rows for analysis and flag entries with missing fields.
Your Google Sheets table gains valid entries from new JSON responses, with rejected entries listed for review.
Email a requested spreadsheet tab as a CSV for analysis.
Get the requested spreadsheet tab into your colleague's inbox as a CSV file. Your request row shows what happened.
Start analysis from usable CSV rows and review source line errors.
Your analysts get CSVs from new text exports in a shared folder. A companion report points to source lines that need fixing.
Combine weekly extracts and count exact duplicates removed.
Get a downloadable CSV from your teams' weekly extracts when the files are usable. See what needs attention in a summary beside it.
Deliver checked data extracts to colleagues each month.
Get a dated CSV and row count in your shared folder every month, or an error note explaining why the export stopped.
Export updated query results with the agreed column headings.
Your report preparer gets a fresh Excel workbook when the SQL reporting table changes. The rows follow your chosen query and headings.