Why connect themThe Number to Words API in Google Sheets.
Google Sheets is the go-to collaborative spreadsheet for teams worldwide. Connecting APIs to Google Sheets transforms your spreadsheets into dynamic, self-updating data hubs. Automatically populate rows with API responses, validate data in real-time, and create living dashboards that reflect the latest information.
What you can buildWorkflows worth wiring.
Automatically validate email addresses in a contact list and flag invalid entries
Build a real-time currency conversion tracker that updates exchange rates hourly
Create a lead scoring spreadsheet that enriches contact data with IP geolocation
Monitor domain SSL certificates and log expiration dates for your portfolio
TemplatesReady-made ideas.
New row added in Google Sheets Fetch number to words for numeric column → write words and ordinal values back to the rowConvert Numbers to Words in Google Sheets
Automatically populate word form columns with the words and ordinal fields when a number is entered in a spreadsheet.
Row updated in Google Sheets Fetch number to words for invoice amount → write words to the written amount columnInvoice Amount Formatter in Google Sheets
Convert invoice amounts to their written word form using the words field for check-writing and legal compliance.
SetupConnect it in a few steps.
Set up with Zapier
- 1
Set the trigger. Create a Zap with Google Sheets as the trigger app and "New row added" as the event. Connect your account.
- 2
Add the API action. Add APIVerve as the action, select the Number to Words API, and map your trigger data to the request.
- 3
Send it back. Add a second Google Sheets action for "Add row" and map the returned fields (like number) 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 Google Sheets module set to "New row added". Authenticate your account.
- 2
Call the API. Add an HTTP module pointing at api.apiverve.com/v1/numbertowords 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 Google Sheets module for "Add row". Map fields like data.number into place.
- 4
Activate. Run once to confirm the mapping, then switch the scenario on and set its schedule.
Set up with n8n
- 1
Add the trigger node. Start a workflow with a Google Sheets trigger node for "New row added" and connect your credentials.
- 2
Add an HTTP Request node. Point it at api.apiverve.com/v1/numbertowords using Header Auth (x-api-key). Feed in the trigger data.
- 3
Map with expressions. Add a Google Sheets node for "Add row" and reference the response with expressions such as {{ $json.data.number }}.
- 4
Execute & activate. Execute manually to verify, then activate the workflow for production.
The payloadWhat Google Sheets receives.
number975.07
words"nine hundred seventy-five point zero seven"
ordinal"nine hundred seventy-fifth point zero seven"
numberOfDigits_numeric3
numberOfDigits_words"three"
eachNumberarray of 3