Pull Data From Google Sheets, Upload To API To Search For Data then Pull Results from API Into Sheets

I would like to pull data from my Google Sheets, then upload this data to an API to search with this data then pull the results from this API back into sheets or CSV.

I’ve integrated my Sheets so I already pulled the data, but I can’t work out how to initiate the search then pull the results.

Hi @D_M,

Try using the Enrich with an API step!

This step can send the values from your Google Sheet import directly to an API. It will also pull in the results back from your request.

From there, you can clean your data to export it to a Google Sheet or CSV file.