Hey Maricar,
You're right, this actually requires one extra step compared to the FTP file creation showed in the example I provided.
This is one of the more complicated things that you can do in integrator.io, but you'll be able to do it! We need to add a preSavePage hook to the Export from Google Sheets.
First you'll need to enable Developer Mode if you haven't yet. Go to My Profile (in the top right) and check the checkbox for Developer Mode. You might have to set a Time Zone as well to save the page.
Then, you'll want to click the little "+" icon on the Google Sheets export, and click the icon that looks like a fish hook. Click the "+" to the right of the Scripts field, name the script "Rows to Records", and enter the following text under Edit content:
function preSavePage (options) {
return {
data: options.data[0],
errors: options.errors,
abort: false
}
}It should look like this:
And when you click save, enter preSavePage for the function and click save on this page, like this:
Now, your flow should work as expected!