I tried replicating the output for the lead generation agent, but failed to retrieve google sheets link:

Please take a look

p.s: Tested google sheets integration, which seems to be fine