Transferring CSV data to Google Sheet via AppScript

Hi there,

Last year, I stumbled upon a forum or a website that taught me how to export Asana’s CSV to Google Sheet via AppScript. From there, I would use LookerStudio to create the reporting type that would be useful for my report.

Being a total noob, I forgot to jot down the process, and now I completely forget to how to get certain information.

Here’s the part that I am lost now:

var url = 'https://app.asana.com/-/csv_signed?hash=XXXXXXX&domain_user=YYYYYYY&id=ZZZZZ';

I have completely forgot how did I get the information for hash, domain_user, and id for that project of mine. I would like to replicate the code to another project of mine.

Could someone help with this?

Thank you.

1 Like