Copy information on the screen, then copy and set it on another sheet, in particular a specific cell

Ask for Help
1

Hello,
I would like to modify a specific cell in a Google Sheets spreadsheet. My aim is to retrieve the information from my current page, in particular the “Batch number”, in order to copy and paste it into a specific cell on another sheet. Via an action button?

Is this possible with a free version?

2

It would only be possible if you have a Legacy Free Plan, as the new Free Plans do not allow you to connect to a Google Spreadsheet.

3

I’m able to connect to the Google Sheet spreadsheet without any problem. What is the procedure for performing this action?

4

Create a single relation from the current row to the row in the other table that you want to update, then use a Set Column Values action to change the value.

2 Likes