Skip to main content
Best answer

How to email an XLSX attachment from Gmail to SQL using Zapier?

  • July 17, 2025
  • 1 reply
  • 14 views

Hi 👋

Created  a zap ⚡ that checks gmail incoming for attachment (flex)  and subject.

It manages to upload file 📎 to google drive. 

I then using find file 📎 get its is

I use sql ger many rows using the upload file 📎 is but I get error rupees/ed entity not found.  

 

Suggestions? 

 

Best answer by JammerS

Hi ​@mrrcomp,

 

Welcome to the Community,

Thanks for reaching out to the Zapier Community! You're having trouble using a Google Drive file ID to query your SQL database. Start by verifying that the file ID from the "Find File" step is accurate. Then, review your SQL query to ensure it's properly formatted and matches your database structure. Double-check your database connection in Zapier and test the query with a known file ID to isolate the issue. Use Zapier’s testing tools and error messages to pinpoint where things may be going wrong.

Feel free to reach out if you have any questions or need further assistance.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 3527 replies
  • Answer
  • July 18, 2025

Hi ​@mrrcomp,

 

Welcome to the Community,

Thanks for reaching out to the Zapier Community! You're having trouble using a Google Drive file ID to query your SQL database. Start by verifying that the file ID from the "Find File" step is accurate. Then, review your SQL query to ensure it's properly formatted and matches your database structure. Double-check your database connection in Zapier and test the query with a known file ID to isolate the issue. Use Zapier’s testing tools and error messages to pinpoint where things may be going wrong.

Feel free to reach out if you have any questions or need further assistance.