How to Email a CSV from Google Sheet Using Make

Have you ever found yourself stuck trying to email out a CSV of a Google Sheet created as part of your automation process? If you're transitioning from Zapier to Make, you might have encountered this challenge. But don't worry, we've got you covered. In this article, we'll walk you through the steps to solve this problem.

Understanding the Problem

The issue arises when you're trying to locate the CSV via the autogenerated link in Google Sheets and send it using Make. This might not work as expected, especially if you're dealing with file permissions. You might have come across suggestions to use an API to change permissions, but that might not have worked either.

The Solution

Here's the good news: the solution is simpler than you think. You can use the same syntax for Zapier in the HTTP - Get a File module in Make. Here's how:

  1. Use 'Google Drive - Get a Share Link' to set the permissions.
  2. Once the permissions are set, the 'HTTP - Get a File' can access it.

Note: This method gets the first sheet, not the second one. If you need the second tab of the Google Sheet as a CSV, you'll need to adjust the settings accordingly.

Troubleshooting Tips

If you're still having trouble, make sure you've correctly set the permissions using 'Google Drive - Get a Share Link'. Also, double-check the syntax you're using in the HTTP - Get a File module.

Conclusion

Transitioning from one automation tool to another can come with its own set of challenges. But with a little patience and the right guidance, you can overcome these hurdles. We hope this article has helped you understand how to email a CSV of a Google Sheet using Make. Happy automating!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.