Why connect themThe SPF Validator API in Microsoft Excel.
Microsoft Excel remains the enterprise standard for data analysis. Connecting APIs to Excel Online enables automated data imports, real-time validation, and dynamic reporting. Bridge your Excel workflows with external data sources seamlessly.
What you can buildWorkflows worth wiring.
Import daily financial data directly into your analysis spreadsheets
Validate customer data entries against external databases in real-time
Build automated reports that pull the latest metrics from various APIs
Create inventory tracking sheets that sync with external systems
TemplatesReady-made ideas.
New row added Validate SPF → write results to adjacent columnsValidate SPF for domain column
Validate SPF records for every domain added to your Excel sheet. Write spf_valid, spf_record, and dns_lookups_num into adjacent columns.
Manual trigger or schedule Loop rows → validate SPF → update status columnsBatch SPF validation for existing domains
Run SPF validation across an entire column of domains. Populate columns with spf_valid, has_issues, and issues_found for each.
SetupConnect it in a few steps.
Set up with Zapier
- 1
Set the trigger. Create a Zap with Microsoft Excel as the trigger app and "New row" as the event. Connect your account.
- 2
Add the API action. Add APIVerve as the action, select the SPF Validator API, and map your trigger data to the request.
- 3
Send it back. Add a second Microsoft Excel action for "Add row" and map the returned fields (like host) into it.
- 4
Test & turn on. Test the Zap with real data to confirm the mapping, then turn it on.
Set up with Make
- 1
Add the trigger. Create a scenario and add a Microsoft Excel module set to "New row". Authenticate your account.
- 2
Call the API. Add an HTTP module pointing at api.apiverve.com/v1/spfvalidator with your x-api-key header. Pass the trigger's data as the input.
- 3
Parse & map. Add a JSON module to read the response, then a Microsoft Excel module for "Add row". Map fields like data.host into place.
- 4
Activate. Run once to confirm the mapping, then switch the scenario on and set its schedule.
The payloadWhat Microsoft Excel receives.
host"myspace.com"
has_spf_recordtrue
dns_lookups_num9
spf_record"v=spf1 mx ip4:63.208.226.34 ip4:204.16.32.0/22 ip4:67.134…"
spf_records_listarray of 9
domains_extractedarray of 9
