Google Sheets: data sent by Zap appears as #ERROR in sheet

Symptoms

In your Google Sheet, you see the #ERROR message in cells where data was sent from Zapier.
 

Causes

This happens if the data you send from Zapier starts with +, as Google Sheets interprets the leading + sign as the start of a formula. This causes Google Sheets to attempt to calculate the value instead of displaying it as text.
 

How to fix it

To resolve this issue, follow these steps:
  • Go to your Zaps.
  • Open your affected Zap.
  • Select the Google Sheets step.
  • Add a single leading apostrophe character'in the affected field before the mapped field. This will force Google Sheets to treat the value as text.
  • Once you’re done editing the Zap, click Publish.
 
 
Was this article helpful?
3 out of 4 found this helpful