# Problem with Google Sheets **URL:** \ **Category:** Questions\ **Tags:** google-sheets\ **Created:** [July 20, 2023, 10:42pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378 "2023-07-20T22:42:50Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 20, 2023, 10:42pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/1 "2023-07-20T22:42:50Z")
Hi there, I’m self-hosting a n8n instance but I have having trouble connecting Google Sheets. My instance is up and running. I’ve created a Google cloud project, created credentials and enable the Google Sheets API according to the documentation. When adding my Google Sheets account to n8n, it says it’s successfully connected. However, when building things in workflows, it says it can’t load the list of my documents and it’s telling me to check the credentials. How can I fix this? Thank you in advance! ![image](https://europe1.discourse-cdn.com/n8n/original/3X/1/5/15409ebe5f8ab40d0986c2c26d89e4499ea59675.png) ![image](https://europe1.discourse-cdn.com/n8n/original/3X/4/9/493b399ac49d54661fcac19ebbe1f3cf6bf2110b.png) ---
**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\ **Post date:** [July 21, 2023, 8:44am UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/3 "2023-07-21T08:44:09Z")
Hi @Ricky_Wolff 👋 Welcome to the community! 🎉 Out of curiosity, might this be a company account that has sheets shared with you, or is this your own personal Sheets account? ---
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 22, 2023, 4:03pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/4 "2023-07-22T16:03:02Z")
Hi there, thank you! This is my personal sheets account ---
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 22, 2023, 4:46pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/5 "2023-07-22T16:46:06Z")
@EmeraldHerald also, I have no issues with other services like Gmail. It seems that Google Sheets it not working ---
**Author:** ![lauge](https://avatars.discourse-cdn.com/v4/letter/l/a698b9/32.png) [@lauge](https://community.n8n.io/u/lauge)\ **Post date:** [July 22, 2023, 5:04pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/6 "2023-07-22T17:04:27Z")
I’m new here. But did you activate the Google Sheets API? [https://console.cloud.google.com/apis/library/sheets.googleapis.com](https://console.cloud.google.com/apis/library/sheets.googleapis.com) ---
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 22, 2023, 5:39pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/7 "2023-07-22T17:39:57Z")
@lauge Yes I did ---
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 22, 2023, 6:19pm UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/8 "2023-07-22T18:19:06Z")
I’ve also tried connecting to a business account, but running into the same issues ☹ ---
**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\ **Post date:** [July 24, 2023, 8:38am UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/9 "2023-07-24T08:38:08Z")
Hmm, can you try the “by ID” option and see if that works here? ![image](https://europe1.discourse-cdn.com/n8n/original/3X/1/4/1486e1444d020a312796eaf212e7250ac90c50db.png) If that works, you might need to also enable this in the [https://console.cloud.google.com/apis/library/drive.googleapis.com](https://console.cloud.google.com/apis/library/drive.googleapis.com) as well, as I believe that’s what fetches the available sheet files 🤔 ---
**Author:** ![Ricky\_Wolff](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/ricky_wolff/32/27609_2.png) [@Ricky\_Wolff](https://community.n8n.io/u/Ricky_Wolff)\ **Post date:** [July 24, 2023, 8:52am UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/10 "2023-07-24T08:52:01Z")
Hey @EmeraldHerald I checked and by URL it seems to be working! Just not when I select from list. I’ve have enabled the Drive API. That indeed allowed the list view to work as well. Thank you for your help! ---
**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/36532_2.png) [@system](https://community.n8n.io/u/system)\ **Post date:** [July 31, 2023, 8:52am UTC](https://community.n8n.io/t/problem-with-google-sheets/28378/11 "2023-07-31T08:52:14Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.