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.