topic Re: Do Lookup for Google Sheets does not work in Qlik Automate

Do Lookup for Google Sheets does not work

chriys1337 — Mon, 06 Jan 2025 17:21:42 GMT

Hi,

I have tried to built an automation, where I append one row to a (Google) Sheet.

For most of the block the "do lookup" where I can easily select afterwards different actions, like in my case one spreadsheet does work.

I am correctly identified against my google account, but the do lookup does not work. I am only able to put in the spreadsheet id manually, but it would be better if I can look all my spreadsheets up and select the appropriate one. Now my question is, why does this not work? Do you have the same issue?

Re: Do Lookup for Google Sheets does not work

David_Friend — Mon, 06 Jan 2025 18:32:55 GMT

@chriys1337 can you share your detailed steps and I'll try the same thing thanks!

Re: Do Lookup for Google Sheets does not work

chriys1337 — Tue, 07 Jan 2025 09:09:01 GMT

Hi David,

I am basically just fetching some variable inputs from an app and want to write them in an google spreadsheet and when doing this, the do lookup from the last block does not work for me (only when I manually put in the spreadsheet id it is working). Thank you for your help!

Chris

Re: Do Lookup for Google Sheets does not work

chriys1337 — Thu, 20 Feb 2025 09:14:57 GMT

Hi @David_Friend , just wanted to check if you had time to look into this, please?