...
Note |
---|
sheet-id must not be confused with spreadsheet-id. In this app sheet-id is the same as gid from the https://docs.google.com/spreadsheets/d/xxxxxxxxxyyyyyyyxxxxxxxyyyyxxx/edit#gid=12345678. The gid represents each tab's in the spreadsheet, and for this link, the sheet-id is 12345678 |
Here's how it will execute:
- Move down all rows at the row-nbr position
- Write the delimited values in the space created in the column-nbr at the row-nbr which is empty after the step 1
Data before :
Data after :
Definition of the card:
With some sample data :
Produced in Google Sheets:
...