Every night a new row in google sheets with the date and one lookup

[Buschi]

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

 

[ArshilAhmad]

Hi @Buschi,

You can setup your workflow in the following manner to achieve this use case.

https://connect.pabbly.com/workflow...dUzYIHAIGAFZSIVdNAQNSUVErB0oDeAxVATIAXgMrUjM#

Date and Value

Sheet1 Name,Value ABC,Demo

docs.google.com

 

[Buschi]

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!