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

Written by Owner

Updated at August 20th, 2025

+ More

Table of Contents

Causes How to fix it Still need help?

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.

Still need help?

If this article did not fix the issue, Zapier has a few other options to get you the help you need:

Contact Zapier Support. Our Support team can investigate your account to find solutions.
Ask in the Zapier Community. Get advice from experienced Zapier users in the Zapier Community.
Learn more about getting help. Read our guide on how to get help and support with Zapier to find the best resources for your specific problem.

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

Contact Us

Causes

How to fix it

Still need help?

Related Articles