How to automate google spreadheet?


I’m trying to automate google sheets (for the purpose of invoice generation). The difficulties which I’m facing is,

  1. I’m not able to select any cells inside the sheet.
    I found a workaround by using image selector and double click events. Is there any better alternative for this?

  2. The major issue which I’m facing is, The page is having an vertical scroll. The elements which is towards bottom is not picking up. I’ve a few fields at to to fill, which is doing correctly. But towards bottom its behaving strangely by filling in invalid columns.

Please assist to solve this.

You may wanna have a look at this custom activity,

Rammohan B.