Skip to main content
Google Sheets: data sent by Zap appears as #ERROR in sheet
December 04, 2023 14:01
In your Google Sheet, you see the #ERROR message in cells where data was sent from Zapier.
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
Was this article helpful?
1 out of 1 found this helpful
Get help from Zapier Support.
Find answers and inspiration.
Hire an Expert
Leverage professionals across the globe ready to help.
Take courses designed to help you become a better Zapier user.
Read the Zapier blog for tips on productivity, automation, and growing your business.
Learn about automation anytime, anywhere with our on-demand webinar library.
field types, troubleshoot errors, data privacy