MySQL Phone Intelligence Report with Abstract API

Fetch contact phone numbers from MySQL, inspect validity, carrier, location, and risk signals through Abstract API, and download a CSV report.

Use this template Browse all templates

Workflow preview

Drag to pan, click a step to center it, or use the controls to fit and zoom.

Loading workflow preview…
  1. Manual run
  2. Fetch contact phone rows from MySQL
  3. Inspect unique phone numbers through Abstract API
  4. Create an Excel-compatible CSV report
  5. Download report from the completed run
Read-only preview Loading preview…

What this workflow does

Fetch contact phone numbers from MySQL, inspect validity, carrier, location, and risk signals through Abstract API, and download a CSV report. Produce an Excel-compatible phone intelligence report that preserves every selected row and separates valid, review, invalid, and skipped numbers.

Trigger
Phone intelligence report started Run manually with a deliberately small batch first. The workflow reads contact rows and sends only each unique phone number plus its country context to Abstract API.
Primary output
Inspect contact phone list 3 configured workflow actions

Template details

Category

Data Automation

Workflow includes
Best for

Operators, sales teams, support teams, and data owners reviewing contact phone data before outreach, migration, or cleanup

Before you use it

The template will guide you through these setup items in the workflow builder.

  1. 1 Connect MySQL with a read-only database user
  2. 2 Connect the Abstract API Phone Intelligence service
  3. 3 Review the starter contacts query and map your phone and country columns
  4. 4 Set a default country for local numbers when needed
  5. 5 Run the included scenario with 25 numbers
  6. 6 Open the completed run or builder test result and download the CSV report

Related templates

Browse templates

MySQL Newsletter Subscribers to Brevo List Sync

Fetch verified newsletter opt-ins from MySQL, pause for human review, and queue a bulk Brevo import into a required contact list.

MySQL Email Deliverability Report with Abstract API

Fetch user email addresses from MySQL, validate deliverability through Abstract API, and download a CSV report separating valid, review, and invalid results.

MySQL IP Intelligence Report with Abstract API

Fetch recently active users and their recorded IP addresses from MySQL, inspect public IPs through Abstract API, and download a CSV risk report.