# Google sheets - Can't find my files **URL:** \ **Category:** Questions & Help\ **Created:** [September 2, 2025, 11:49pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533 "2025-09-02T23:49:38Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 2, 2025, 11:49pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/1 "2025-09-02T23:49:38Z")
As the title already reveals, when I try to select a document in the flow, I can’t find any… ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [September 3, 2025, 10:55am UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/2 "2025-09-03T10:55:06Z")
EDIT probably this is the trick; however, when I add the ‘Google Sheets’ device to Homey, I don’t get to see this screen anywhere (phone, laptop): > [@\[APP\] Google Sheets - Append to Google Sheets from a Flow](https://community.homey.app/t/app-google-sheets-append-to-google-sheets-from-a-flow/107101/6): > > Did you also tick these two boxes when creating the Google Sheets User device? > > ![Screenshot 2023-01-15 at 11.47.07](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/5/e555a1248904c44ace2a887b2f9abcdd185ed34a.png) . Original reply: I just tested it, I can’t “select” a file, you’re supposed enter the URL to the file yourself; How to get the URL: In the mobile Spreadsheets app, you can copy the URL (or ‘Link’) by hitting the 3 dots next to the spreadsheet (this might work with Google drive as well): ![Screenshot_20250903_133215_Sheets](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/0/30e8ad28c176e2c3fb090fbe0f990cfdc0291c61.jpeg) Next, tap “copy link”: ![Screenshot_20250903_133411_Google](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/8/780bc6a6647446343d3d9429a16acf044975bb29.jpeg) Now paste that link into the “URL to document” field: ![Screenshot_20250903_133622_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/e/d/edb04f9902fe97027bfbfb3ccf7aa3757f4f12e2.jpeg) If all went well, you can select the sheet to use: ![Screenshot_20250903_132458_Chrome](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/1/a1283f859ee08fbeacb885414e663827bad6f609.jpeg) ---
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 3, 2025, 7:34pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/3 "2025-09-03T19:34:05Z")
Peter, I can assure you that everything you’re saying and showing here is something I’ve already done… **But how stupid can someone be…** If a Google Sheets User device is created with one Google account and you then start creating a Google spreadsheet with another Google account, what are the chances of this working? Zero, nada, niente, zilch, noppes, rien de knots, nought, geen ballen…!!! So, thank you all for your support, and I’m sorry for wasting your time, but now I’m going to get drunk… But if you haven’t figured out what I’m trying to tell you here… it works now… ---
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 3, 2025, 7:38pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/4 "2025-09-03T19:38:46Z")
Now stop laughing, I can hear you !!! ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [September 3, 2025, 8:31pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/5 "2025-09-03T20:31:35Z")
All’s cool 🤸 I was just curious how this should work 🤪 +1 for admitting the account confusion 😬 Now how do you get to select the files? I didn’t figure it out 😂 ---
**Author:** ![JST1963](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jst1963/32/140722_2.png) [@JST1963](https://community.homey.app/u/JST1963)\ **Post date:** [September 3, 2025, 8:40pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/6 "2025-09-03T20:40:57Z")
Nah…I had to do exactly what you did: copy & paste. But once this path was inserted correctly, I could at least select the page (or workbook if you want). Before I always got a 403 or a 404 error. I think this is gonna be one of my favorite apps…like making some nice graphics with the ecar data 🙂 ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [September 3, 2025, 8:49pm UTC](https://community.homey.app/t/google-sheets-cant-find-my-files/142533/7 "2025-09-03T20:49:47Z")
Ah, I see. I hit the the dreaded “rate limit” after a while, so I tossed it quickly into the 🔥 Tested with solar panel power data, which changes all the time. Not appreciated by Google 😂