Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have a Google Form which has the field “ИНН” and this field can start from zero (“0”) and has a numeric format (I checked this with the Zapier ISTEXT(value) formula)

But i need save this “0”

I use “Lookup Spreadsheet Row in Google Sheets” action to write values to Google Sheets and after that action “0” lost

Before action: 
 


After action:

 

 

Can you help me? What function should i use? 

Hi @devopsuser , 

 

This might be from Google Sheets side maybe? I mean is this column in Google Sheets set to format Text already and not Auto ? 

 

Hi @devopsuser , 

 

This might be from Google Sheets side maybe? I mean is this column in Google Sheets set to format Text already and not Auto ? 

 

In Google Sheets this column already in Text format (it didn't help)

The values are truncated after Zapier in the table

Example below:

 


The red values are smaller in length due to the clipped zero at the beginning

Hi @devopsuser 

 

I found this resource for google sheets tips on adding the leading zero, I think it can help 

 

https://www.oksheets.com/add-leading-zeros/

 

I would use the apostrophe one :)

Hey there, @devopsuser! I wanted to check in and see if you were able to get this sorted with @MohSwellam recommendations? 🤗

Keep us posted! We’d love to know!

Reply


Terms & Conditions