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.
Send us a ticket, we will try our best to assist you with your problem