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
Screenshot 2: Customer Workflow
Screenshot 3: Product Workflow
Looking forward your help and feedback 🙂
Best,
Kevin
Solved! Go to Solution.
Hello @Kevincoco
Please take a look at the Help doc for the Google Sheets Input Tool.
This should help you to move forward with the changes you are looking to make!
Thanks,
TrevorS
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