I have a dynamic google sheets tab where a new row gets added when new info flows in from zapier.
I want to GET info from only 6 columns on the sheet row that was added which are: fname, lname, address, city, state, and zip.
Then send this row info with specific data columns info to an API endpoint (www.datafinder.com), which if successful gives me contact info of phone numbers and email addresses.
I want the NEW data to get appended back to the same sheet row in a newly established columns.
Totally new to parabola my first hurdle is lining up the keys and values so the data from the google sheets columns maps directly to the query parameters for the API to get the new data.
2nd hurdle will be inputting the new data back into google sheets on the same row.
Any pointers especially with the first hurdle will help. Thanks.
Sounds like you want to use a Google Sheets Import, then use an API Enrichment step to hit that API and merge in some values into the API request, then use a Column Rename step probably to rename those columns you got back, and a Column Filter to only keep those you need, and then finally overwriting your Google Sheet to map the new data into the sheet, since you can’t just append new columns, only new rows.
Thanks for the screenshots! I think you can remove the JSON Flattener step because judging from your screenshots, it doesn’t look like you need to flatten any data from your Google Sheet.
As for what to put in the Header Key, it depends on what the API requires. If it doesn’t require an additional Header Key, you can click the “X” icon to remove the second Header Key. I tried to look up their API documentation, but it looks like it’s not publicly available without an account.
The way API Enrichment works is that you pass the data to the API by wrapping curly braces {} around your column name. So, for example, if I wanted to call the API for a specific mailing address, I would put {Mailing Address} either in the API Endpoint URL or the Body (if you’re making a POST call). Again, the exact formatting depends on what the API requires.
Does that help? If you’re able to link to the docs or post some screenshots, that’ll help us out.
Those docs links didn’t seem to come through. Could you send the PDF documents to help@parabola.io and we will take a look. At first glance, it seems like the / between all of your attributes should be a & instead.
