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.

Hi,

I’ve just created my first Zap!

What it does is create a new row in a Google Sheet every time an email matching a certain criteria is received. The criteria is that the email are in a specific folder and they are displayed in Google Sheet .

The columns in the Google Sheet are: Sender Name, CC includes, Title of the Mail, Date & Time, No. of Attachment, Attachment Details.

I have tested my zap by sending an email from that email address with a .jpg file but I have received an error that says: There was an error with Google Sheets: Object of type LazyFile is not JSON serializable.

I read on some of your form and found out that the proper way would be to send the attachment to Google Drive.

Now how do I link the mail and attachment to sheets such that it shows the attachment details(image/pdf/word..etc) in front of the sheet Sender Name, Title and other details.

Hi there @khuzi, welcome to the Community! 😁

Looking at this related topic in Community it’s not possible to add file to a Google Sheet:


As per the answer in that related topic, you’d want to get the Zap to upload the file to somewhere like Google Drive. Then add a link to view the file (on Google Drive) in the Google Sheet. You can find out more about how to work with files in your Zaps here: Send files in Zaps 

Depending on the trigger app you’re using it might be possible to see the a field that contains the file type for the attachment. Not sure what email app you’re using for the trigger but for example Gmail’s New Attachment trigger has an Attachment Details Mime Type field that contains details of the file type. 

Hope that helps. Please do report back here to let us know how you get on with this!

Terms & Conditions