Custom GPT (Workspace member) to Google Docs (Company Google Account)

[lukeyfrio]

Hello hive mind ! Thanks for the help - Newbie here (be merciful !!)

I built a custom GPT (using my Member access to a work Chat GPT account)…it works great - but the output is just ‘text in chat’

All I am trying to do is put an automation in place where the GPT creates a new Google Doc (in my shared company Google account) and then writes that text into that new doc (instead of as ‘text in chat’)

I am sure this is super achievable - but having messed around with tutorials / Apps Script/creating new Google Cloud service accounts/ Zapier - I am going nowhere fast
My gut tells me this is due to permissions and having admin level access to change settings on Chat GPT or Google Cloud (for the APIs) - but if anyone has any thoughts they would be much appreciated !!

Thanks

[mat.eo]

Hey Lukey, yes this is certainly possible.

If you are looking to accomplish this inside of ChatGPT you are going to need a custom action, along with setting up oauth to facilitate the process. The built-in Google Drive functionality doesn’t accommodate anything past simple RAG.

I’m unfamiliar with the hands-on experience of Zapier, or other no-code workflow builders. However, this can be accomplished without them. It would cost less, and most likely reduce any headaches in the future.

What are your thoughts?

[sergeliatko]

Hi, nice application here. It’s hard to tell what issue exactly are you having without looking into code and the implementation. But I would start with this link and see what you’re missing: Create and manage documents  |  Google Docs  |  Google for Developers

And then if I would listen to my gut, I would start checking if authorization and scopes are properly implemented between the chat and Google so that the chat is actually allowed to act on your behalf as expected.

[lukeyfrio]

Hi @sergeliatko @mat.eo - and many thanks for taking the time to reply here.

Great to know that this is achievable ! And that Zapier not necessary for this task.

The documents I need to create are the same each time (actually briefing notes for interviews). I use the exact same ‘template’ each time for these - same fonts, headings, content etc etc…and I have approx 20 existing briefing docs that I made manually myself (all in google docs - one of which I used as the Knowledge for the GPT I made).

However - with no coding background and little time at work to fix this I am very stuck! I tried asking my custom GPT to give me the instructions / the code needed from Actions…but we couldn’t get it to work!

I will look into ‘custom actions’ ‘oauth’ and ‘authorization and scopes’ and see how I go !

[lukeyfrio]

Just a quick update - I am pausing at this stage in the process - pending some potential input from folks here like the amazing @mat.eo @sergeliatko !!!

Stuck on Automating ChatGPT → Google Docs Webhook

Goal:

We are trying to automate the creation of Google Docs from ChatGPT’s responses via a Google Apps Script Web App Webhook.

Current Progress:

Google Apps Script Web App is deployed and receives data.
Manually sending a cURL request from Terminal creates a Google Doc successfully.
Webhook correctly formats the briefing data and saves it in the right Google Drive folder.

The Issue:

When ChatGPT sends the Webhook request, no document is created.
No error is returned in ChatGPT or Google Apps Script Logs.
Terminal test works, but the same request from ChatGPT does not.

What We Have Tried:

1. Ensured Web App is public (“Anyone can access”)
2. Updated Google Drive permissions (service account has Editor access)
3. Enabled Google Drive & Docs APIs in Google Cloud Console
4. Tested manual cURL request ( it works)
5. Checked Google Apps Script logs (no errors, but no sign of ChatGPT’s request)
6. Tried using both the initial Web App URL and the redirected execution URL

Questions for the OpenAI Community:

• Does ChatGPT’s Webhook tool handle URL redirects (302 “Moved Temporarily”)?
• Are there restrictions on external API calls from ChatGPT to Google Apps Script?
• Has anyone successfully connected ChatGPT to Google Apps Script Web Apps?
• What’s the best way to debug external API calls from ChatGPT when no error logs appear?

Any help would be greatly appreciated! Thanks in advance!

[mat.eo]

Ok, I noticed one quick thing.

@lukeyfrio

creating new Google Cloud service accounts

@lukeyfrio

• Updated Google Drive permissions (service account has Editor access)

@lukeyfrio

Google Apps Script Web App is deployed and receives data.

For whatever reason the API does not work with service accounts.

I just wanted to clear that up.

You are going to need to setup oauth.

Enabling script authorization and access  |  Apps Script...

[lukeyfrio]

Need Help Sending Webhook Requests from Custom GPT to Zapier

Hi everyone,

We’ve been trying to set up an automation where our Custom GPT sends interview briefing data directly to Zapier Webhooks, which then creates a Google Doc.

After multiple failed attempts using OAuth & Google Docs API, we’ve decided to only use Zapier Webhooks for this integration. However, we are facing an issue where ChatGPT’s Webhook requests are not reaching Zapier.

---

What Works So Far

• Zapier Webhook is active and successfully receives data when tested using cURL from my terminal.
• Google Docs creation works perfectly when Zapier receives the data.
• ChatGPT’s Webhook requests do not appear in Zapier (or even in a RequestBin test).

---

What’s Failing

• When ChatGPT sends a Webhook request, Zapier detects nothing.
• When sending the same request manually via cURL, Zapier detects it immediately.
• To verify, we tested sending the request to RequestBin, and it also received nothing from ChatGPT.

---

Test Webhook Details

Here’s the test Webhook URL we used:
(I can share if needed)

Here’s the sample JSON payload we sent:

json

CopyEdit

{
    "title": "Interview Briefing - Luke x BBC",
    "interviewer": "Paul",
    "outlet": "BBC",
    "spokesperson": "Luke",
    "topics": "Google Docs API integration, Automating workflows with Zapier, Challenges with OAuth & Service Accounts",
    "talkingPoints": "Successfully automated Google Docs creation using Zapier. Overcame challenges with OAuth and service accounts. Explored alternative methods including Python, cURL, and Google Cloud SDK."
}

---

Debugging So Far

• Zapier receives the request when sent manually via cURL.
• Zapier works correctly when manually triggering the Webhook.
• Zapier does not receive anything from ChatGPT’s Webhook.
• A test request to RequestBin from ChatGPT also failed.

---

Questions for the Community

Does ChatGPT handle Webhook requests differently than a standard cURL request?
Are there known limitations on Webhook requests from ChatGPT?
What’s the best way to debug Webhooks that don’t leave ChatGPT?

Would really appreciate any help on getting ChatGPT → Zapier Webhooks working!

Thanks in advance!