Every night a new row in google sheets with the date and one lookup
Status: Closed · Asked by Buschi on · 0 views
Hi folks,
It's probably super simple, but I just can't figure it out. The following requirement:
Every night at 1 o'clock Pabbly should go into a google spreadsheet and take the value from sheet A from always the same cell (B2) and enter it in the same spreadsheet in sheet B with the date from this automation in column A and the value in column B continuously.
Any ideas?
Thank you
Hi @Buschi,
You can setup your workflow in the following manner to achieve this use case.
https://docs.google.com/spreadsheets/d/1wsK_7rT46FWXCUdHR4tPYQzc1HKmYCKlC0bqBLEjoUk/edit#gid=0
Thx. I am pretty sure that I made it the same way, but got errors. Anyhow. It works and it is so easy. Your help is very much appreciated. Have a good day!