Write a code sample of (query/script) for personalized automation & AI programming task

SAMPLE INPUT & OUTCOME: https://bit.ly/write-code-prompt 1. already had techstack: {Glide app builder platform; google sheet with api connector already had: GPT, digital channels for pull, push actions} 2. data/workflow need api to perform: {marketing content & report data for website wordpress and fanpage, including text & image for post & article; workflow from landing button straight to GPT UI lookalike dashboard, then user just need to put prompts, the tool suggests} 3. Where the query/ script needed to be put in (with specific action outcome if any): {2 version: 1 for Google appscript, 1 for bigquery, to auto create client sheet and connect GPT api key given before, then auto fetch GPT reply by user prompt imput}