Update one Google Sheet from another

How To
1

I have two google spreadsheets.

The first spreadsheet has various data types, I’m looking to update one of these data types in another spreadsheet with multiple sheets

The data type to be mapped is the date. The common reference between the sheets is the Id Number.

I need to search the second spreadsheet for the ID number which is on it’s own seperate row. When that ID has been identified I need to update a cell on the same row with the date from the first Spreadsheet.

I suppose the first question should be, can you update multiple sheets in one spreadsheet or do they need to be updated individually.

Appreciate any advice.

3

Hey Bruce,

you can’t update different sheets with the same operation, you will need separate modules for each sheet.

There is the Make an API call generic module that can be used for this, but you will need to build your own call with it.