How to retrieve & replace Google Sheet input tool connection token information?

Kevincoco

Hi the Alteryx Community,

I would like to know:
1- How can I retrieve the connection token of one of my Google Sheet Inputs tool (Master Connection Token Workflow Alteryx file cf. screenshot 1)?

2- And use it to replace the connection token of other Google Sheet Inputs tool in other Alteryx files (Customer Workflow & Product Workflow cf. screenshots 2 & 3)?

Screenshot 1: Master Connection Token Workflow

Master Connection Token Workflow

Screenshot 2: Customer Workflow

Customer Workflow

Screenshot 3: Product Workflow

Product Workflow

Looking forward your help and feedback 🙂

Best,

Kevin

Master Connection Token Workflow.PNG

Product Workflow.PNG

Customer Workflow.PNG

Kevincoco

Thanks TrevorS,

I actually figure out a solution with the help of Alteryx experts (alteryx virtual solution center) which is to:
1- use one input google sheet tool to authenticate and generate a connection token

2- save this token in a csv

3- use a macro to populate this connection token to all other google sheet input tools

It works!

Best,

Kevin