Question

Zapier shows data field but when Zap works data does not appear in a created Google Doc

  • 21 November 2019
  • 7 replies
  • 725 views

Userlevel 2

Using Zapier to create a google doc from a template when a new response is created in google forms.

Placeholders a set up correctly in the doc template and show on Zapier. All placeholders show up as optional field in Zapier. However, when I tested the zap, only non-text data is transferring from forms into the template. Zapier actually shows the field but when Zap works non-text data does not appear in the created Google Doc.

Any ideas would be greatly appreciated.



This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +10

Hi @Nethbacca - happy to try and help here.

First off, can you take a screenshot of how you have the placeholders setup in the action step - we can check for any issues there.

Have you tested this zap live before? If so it would also be useful to get a screenshot from the logs of the output data from the step where the template is created.


Userlevel 2

Here is a screenshot of the placeholders set up in part 2 of my zap:

zapscreenshot1.pngThis is a good representation because Security Deposit = text field; LBP Disclosure = yes/no checkboxes; and Recurring Payments = checkboxes

Not sure how to get a screenshot from the logs of the output data from the step where the template is created. Is this output data below the window of "Send Data" option?



Userlevel 7
Badge +10

So everything looks right here.

As for the logs, if you go to the History tab, you’ll see a list of all the times the zap has run. Find an instance of this zap then open it.

Inside you’ll find something like this:

02E0E405-82F0-4FF2-AC44-E5D2E2F73145.jpgCan you get the “Data In” and “Data Out” section for that second step of the zap.


Userlevel 2

Data In:

template_field__Subject_State:ca

file:15DoJ8U4kG6Elh4tUv4MSmbx86n9xmX0R1M1leS5uQfI

template_field__Additional_Tenant:Yes

template_field__Recurring_Payments:Gas, Water, Electricity, Trash / Sewer, HOA, Property Taxes, Insurance

title:new property text 1

template_field__Phone2:555-555-5252

template_field__Phone1:555-555-5555

template_field__Subject_Zip:55555

template_field__Tenant_Paid_Utilities:Electricity, Trash

folder:root

template_field__Pets:No

template_field__Occupancy_Status:Occupied

template_field__TenLast:Doe

template_field__Email:jdoe@jdoe.com

template_field__Subject_Property_Address1:555 main st #4

template_field__Photo_ID:No

template_field__Rental_Agreement:Month to Month

template_field__TenFirst:John

template_field__Maintenance_Recommended:paint interior

template_field__Client_Feedback:ok to paint interior

template_field__Subject_City:anywhere

template_field__Existing_Owner:Test Account 1

template_field__LBP_Disclosure:No

template_field__Pet_Policy:Dogs, Cats

template_field__Security_Deposit:500

template_field__Rent:500

Data Out:

mimeType:application/vnd.google-apps.document

version:3

appDataContents:false

labels:

restricted:false

starred:false

hidden:false

viewed:true

trashed:false

spaces:

1:drive

etag:"vpHqhmVJJUKkibTbTWPfSoPShmE/MTU3NDM3OTI4MTM3MA"

lastModifyingUserName:REMOVED BY COMMUNITY MOD

writersCanShare:false

owners:

1:

picture:

url:https://lh3.googleusercontent.com/a-/AAuE7mBXGXXtQMP9YFjLjWPoJdTcH2Mm1jwewqnFhqtLKZ4=s64

permissionId:03373116669778251447

displayName:REMOVED BY COMMUNITY MOD

kind:drive#user

isAuthenticatedUser:true

emailAddress:REMOVED BY COMMUNITY MOD

id:1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ

lastModifyingUser:

picture:

url:https://lh3.googleusercontent.com/a-/AAuE7mBXGXXtQMP9YFjLjWPoJdTcH2Mm1jwewqnFhqtLKZ4=s64

permissionId:03373116669778251447

displayName:REMOVED BY COMMUNITY MOD

kind:drive#user

isAuthenticatedUser:true

emailAddress:REMOVED BY COMMUNITY MOD

title:new property text 1

ownerNames:

1:REMOVED BY COMMUNITY MOD

capabilities:

canCopy:true

canEdit:true

lastViewedByMeDate:2019-11-21T23:34:41.370Z

parents:

1:

isRoot:true

parentLink:https://www.googleapis.com/drive/v2/files/0APvcNFnxgY7mUk9PVA

id:0APvcNFnxgY7mUk9PVA

selfLink:https://www.googleapis.com/drive/v2/files/1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ/parents/0APvcNFnxgY7mUk9PVA

kind:drive#parentReference

exportLinks:

text/html:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=html

application/pdf:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=pdf

application/vnd.openxmlformats-officedocument.wordprocessingml.document:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=docx

application/vnd.oasis.opendocument.text:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=odt

application/zip:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=zip

application/epub+zip:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=epub

application/rtf:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=rtf

text/plain:https://docs.google.com/feeds/download/documents/export/Export?id=1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ&exportFormat=txt

shared:false

copyRequiresWriterPermission:false

editable:true

markedViewedByMeDate:1970-01-01T00:00:00.000Z

modifiedDate:2019-11-21T23:34:41.370Z

createdDate:2019-11-21T23:34:41.370Z

iconLink:https://drive-thirdparty.googleusercontent.com/16/type/application/vnd.google-apps.document

embedLink:https://docs.google.com/document/d/1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ/preview?ouid=116189215591522454644

kind:drive#file

alternateLink:https://docs.google.com/document/d/1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ/edit?usp=drivesdk

copyable:true

modifiedByMeDate:2019-11-21T23:34:41.370Z

userPermission:

kind:drive#permission

etag:"vpHqhmVJJUKkibTbTWPfSoPShmE/RKTDwIMRikwNvQ8vdHZl05b_RJE"

role:owner

type:user

id:me

selfLink:https://www.googleapis.com/drive/v2/files/1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ/permissions/me

explicitlyTrashed:false

quotaBytesUsed:0

selfLink:https://www.googleapis.com/drive/v2/files/1C3VbEz_jPUSXxrYQ63ns2iMRjOoa-zUn6_XigbqyDNQ


Edited by Danvers (Community Mod) to remove user name and email addresses.


Userlevel 7
Badge +10

Ok thanks @Nethbacca - your first post was a little contradictory. Is it only non-text data that is appearing, or everything but non-text data appearing?


Userlevel 2

Sorry for the confusion. It is only text data that is appearing. Non-text data is not appearing.


Userlevel 7
Badge +10

Ok, can you try this @Nethbacca - for one of the non-text fields can you pass it through a “Formatter->Utilities->Line Item To Text” step and then map the result of that into the template.

Test and see if that makes a difference.