Question

Unable to map Google Forms placeholders to Google Sheets fields

  • 3 August 2023
  • 1 reply
  • 31 views

Hello, 

My zap is simple. Client put them information (name, adress, birth date etc) to a google forms, this forms is connected to a google sheets and I would like to get a new contract when someone fill the forms, but inside the contract we need to change (Name, adress birth date etc) with some Placeholders like this {{name}}, {{address}} etc. But I can’t mapp them to the action ! its not appear, how can I do it ? 

 


1 reply

Userlevel 7
Badge +14

Hi @Maxime Halley 

My template fields aren't appearing in Zapier or they all have generic names

This may be due to your template format. Remove any HTML formatting, and check your template field formatting.

Remove any HTML formatting

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:

Manually enter the template field

  1. Delete the template field and the text around the template field
  2. Manually type in the template field and the text around it.

Remove formatting

  1. Highlight the template fields.
  2. In the top menu, click Format.
  3. 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.

Check your template field formatting

To correctly format your template fields in Google Docs:

  • Template fields must be wrapped in double curly braces.
  • Remove any spaces.
  • Remove any special characters like punctuation marks.
actionEdit icon Example

Here’s an example of a properly formatted template field: {{MyTemplateField}}.

Learn more about how to create and autopopulate a Google Docs template.

Reply