How to Access Google Workspace Files on Make.com

Have you ever tried to add a row to a Google Sheets file that's been shared with you, only to find that you can't locate the file? You're not alone. This is a common issue that many Make.com users encounter, especially when the file is shared from a Google Workspace account to a personal Google account.

The Problem

The problem arises when you try to use the Google Drive API to read Google Workspace files that are shared with your personal account. You might have noticed certain icons that identify files from an organisation’s Google Workspace account. These files can't be accessed by a personal Google account through the API.

The Solution

Fortunately, there's a simple workaround for this issue. You need to change the module’s connection to use a user account that is a member of that Google Workspace, instead of a personal Google account. This will allow you to access and modify the shared files as needed.

Troubleshooting Tips

If you're still having trouble after switching accounts, make sure that the Google Workspace account has the necessary permissions to access the file. Also, double-check that you're using the correct account in the module’s connection settings.

Summary

In conclusion, while it can be frustrating to not be able to find a shared Google Sheets file, the solution is as simple as switching the account you're using in the module’s connection settings. Remember, when working with files shared from a Google Workspace account, always use a Google Workspace account to access them.

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.