Any help with troubleshooting why 6 fields aren't pulling through would be great.
Thanks.
Page 1 / 1
Hi,
Sadly this isn’t solved.
The zap was still pulling through incorrect fields, so I have decided to turn off the Zap and try and build a new one.
I’m trying to set up a new Zap, but am failing at 2 Create Document from Template in Google Docs stage - it can’t find the Google Doc template file in the set up action > template document.
Why is this proving to be such a headache? :(
Thanks
Hey Jessie,
Thanks for getting back to me. The drive isn’t a team drive, and I managed to get it connected to the word template doc the first time round (lets call this Zap 1 - this zap was pulling incorrect fields) so have turned Zap 1 off.
This (Zap 2) can’t find the template document from my google drive, but it can find the Google sheet.
Do I need to disconnect and reconnect my google drive to Zapier? Will this affect my other (working) zaps?
Thanks
Here's what the zap looks like, unable to find any google doc files
Hey @CPS Hmm, this one has me stumped as well! Is “Zap 2” still not able to find the template even if you use this workaround?
If things still aren’t working after using the template ID and reconnecting, it’s likely time to take this one to our support team for further digging: https://zapier.com/app/get-help
If you copy and pasted fields in your template, they may contain HTML formatting. The HTML formatting won't be visible in your Google Doc, but you will need to remove it before using your Doc in Zapier.
There are two ways to delete the HTML in your Google Docs template:
Delete the template field and the text around the template field
Manually type in the template field and the text around it.
Remove formatting
Highlight the template fields.
In the top menu, click Format.
Select Clear formatting.
If you already selected the template in your Zap, click Refresh fields at the bottom of your Google Docs step. This will reload your template and display your template fields.
The Create Document from Template Action will only display templates that you created in Google Docs. It won't display existing templates created by Google Docs. Learn more about each template type.
Hi Troy,
Thanks for your help with this! I rebuilt the Google Doc template with {{MyTemplateField}} and the test went through great.
When I ran the zap all the data came through incorrectly (and now I’ve run out of tasks!)
The {{Name}} {{Surname}} 2022 should generate the google doc file name but it’s hooking up with other fields -
Not sure how to solve this.
Thanks.
Hey Jesse,
Thanks for getting back to me.
I’ve reconnected the google docs & sheets and both are saying test successful
(not sure why it says the account email address on the Google Sheets and not the Docs, even though they are the same account.)
I made a new Zap from scratch (Zap 3) after reconnecting and still coming up with the same issue of not being able to find any Google Docs.
Will email support now with a copy of this thread.
Thanks for your help on this!
@CPS
Make sure your fields are still mapped correctly in the Zap action step that created the GDoc template.
I double checked and can see you were able to open a ticket with support. Looks like they shared this recommendation:
I took a look and was able to pull this in by adding the Doc ID as a custom value in the Zap. Please see below on how to do this in the future. This will then bring in all template fields which you can then map out as usual!
I edited out the actual Doc ID from the original screenshot but it is everything following /d and before the trailing /
I hope this helps!
Hey @CPS oh no, so sorry this has been such a hassle! Let’s see if we can get to the bottom of this. Can you confirm for me the template doesn’t exist on a team drive? I came across this thread which confirms we cannot find a template on a team drive but offers a workaround to get the template ID if this isn’t the case:
Can you tell us more about the incorrect field issue as well? We’d love to keep working through this one with you!
Hey there, @CPS! I wanted to swing by and see if you were able to get this sorted? I took a quick peek at your ticket and it sounds like you may have, which is perfect! Would you mind sharing your solution? We’d love to know.