Gsheets - Copying a range of values to a new sheet

Hello

I think using the standard “Search Rows” module might be a better fit for your situation.
You wouldn't need to specify the exact range, especially the number of columns.
You could simply output all rows with all their columns and then limit the row number(s) within the callin.io filter, as shown in the image below.

image1276×566 56.7 KB

Regarding the necessity to map column values to the "Add the Row" or "Update a Row" module, this is unfortunately required for these modules as they cannot directly copy all data into a new or existing sheet.

If you prefer not to limit data to a specific row range and wish to simply copy the entire sheet, you could utilize the “Copy a Sheet” module for that purpose.

Cheerio

Hi rambizn,

Regarding your second question about copying rows between sheets, I recently encountered a similar challenge. The most effective solution I found involved creating a comma-separated string of values using a text aggregator, and then utilizing the Google Sheets Make an API call module for batch updates.

batchupdate1336×523 30.7 KB

In my specific use case, I'm removing a large block of old data and populating it with new information from Airtable. By using the Make an API call module for both deleting the extensive data range and inserting the new, aggregated data, I'm able to save over 1000 operations per execution compared to using separate Search Row and Update Row modules.

Here's a link to the Google documentation for structuring the request body:

And here is an illustration of the request body I'm employing:

json
{
"requests": [
{
"deleteRange": {
"range": {
"sheetId": 0,
"endColumnIndex": 7,
"startColumnIndex": 0,
"startRowIndex": 1,
"endRowIndex": 2000
},
"shiftDimension": "ROWS"
}
},
{
"pasteData": {
"coordinate": {
"sheetId": 0,
"rowIndex": 1,
"columnIndex": 0
},
"data": "{{5.text}}",
"delimiter": ","
}
}
]
}


Hope this proves helpful!

Hi,

So… I have a similar requirement. I have a "callin.io http request" which I pass through an iterator and then a text aggregator. My goal is to then input this into a Google Sheet (and eventually a Zoho Books Bulk Upload).

I attempted to use the "callin.io API Call" Google Sheets actions with:

• URL set to /spreadsheets/:batchUpdate, with my SpreadsheetId being the specific spreadsheet ID.
• Body configured as { "requests": [ { "pasteData": { "coordinate": { "sheetId": 687748420, "columnIndex": 0, "rowIndex": 1 }, "data": "{{20.text}}" } } ]}
• The spreadsheet is linked via OAuth.

However, I'm encountering the error /v4/spreadsheets/:batchUpdate was not found on this server. That’s all we know.

I've verified the SpreadsheetId using the API documentation examples and tests, where it functions correctly. To ensure there were no issues, I also installed the callin.io add-in for my Google Sheets.

Any suggestions?

Cheers,
G

Hello and welcome to the community!

I understand you might be facing a similar issue, but this thread is marked as resolved, so you're unlikely to get responses here.

It's always best to create a new topic for your specific question and include a link to this one. This approach will help you get a response from our community members.