cosmologyQ: Any more information about google sheets table input?
Hi Diana, great work on this! Ive been playing around with the free trail and so far so good! One thing I am still trying to get my head around is the google sheet connection. I have linked a sheet but can't seem to get it to input the text I have on my sheet. I use the insert text/data and connect the column but nothing happens when I run. Do I need to specify a cell? or maybe format my sheet in a certain way? I could find any tutorials on this. would also love more video tutorials in general!
Diana_ZeroWork
Jun 10, 2024A: Excited to hear you like how your trial goes so far! 🙌
Based on your description, I think you are missing a loop or variable in your TaskBot set-up to actually pull the dynamic data from your Google Sheet. See this common problem page: https://docs.zerowork.io/using-zerowork/common-problems/when-i-use-data-from-table-no-data-is-being-pulled.
For other questions regarding building TaskBots, it's better to ask them in our Discord server. 🙂
Hi Diana, thanks for the fast response! is it possible to pull dynamic data from 1 cell specifically rather than having the loop through the data? I am using this concept to automate filling out a google form using live data from a google sheet.
In general yes, but the ease of doing so depends a bit on the structure of your Sheet. Use conditions to narrow down the column / cell and enter "Start from" in Start Condition building block.
If you want, share your Sheet link on Discord to see the structure and offer a more detailed piece of advice.