Populate a Google Doc template with information from a Salesforce Opportunity
My ideal workflow that I am having a hard time figuring out how to do using Zapier:
a Salesforce opportunity moves into stage = Contracting
feed specific fields from the Salesforce Opportunity into a Google Doc template
email or slack the newly created google doc to specific people
below is my initial attempt at what I think the steps are but it keeps erroring after Zapier can find the Google Template.
Page 1 / 1
Hi @cfalcone01
Good question.
To help us have more context, please post screenshots with how your Zap steps are configured along with the encountered error.
@Troy Tessalone here is my current setup:
The SF stage on the Opportunity changes to ‘5 - Contracting’:
Find my google doc template which I was able to successfully do
Create a document from the template found above - this is where i’m not seeing any options to fill in the fields I’ve built as placeholders on my google doc template (using the {{ }} brackets)
I get an error when trying to test even just adding in the “new document name” field
@cfalcone01
This needs to be the Template Document ID from Step 2.
@Troy Tessalone thank you. I swapped that out and was successfully able to “test” that step. However, I’m still not seeing fields related to the placeholders in my template to feed data into. Those aren’t showing up in the “Create Document from Template in Google Docs” step. Is there another step I’m missing?
Here is a screenshot of step 3 (which is now successful) but still no spots to select what to put into my google doc placeholders.
@Troy Tessalone nevermind - figured it out! I had spaces between my words in my placeholders. Thanks for your help as always!!