When using the Google Sheets connector, is it possible to include the columns as well as the values in a data transformation? We have a sheet that we want to access, that triggers on a new row to hit an endpoint on our service. We need the columns of the sheets to be included in the json payload to our service. I see there are ways to do data transformations via formulas in the recipe, but I haven't been able to figure out how to get the columns.
Ethan Burrow
Google Sheets data transformation
When using the Google Sheets connector, is it possible to include the columns as well as the values in a data transformation? We have a sheet that we want to access, that triggers on a new row to hit an endpoint on our service. We need the columns of the sheets to be included in the json payload to our service. I see there are ways to do data transformations via formulas in the recipe, but I haven't been able to figure out how to get the columns.
1 person likes this idea