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.