# Extract to table is failing for google sheets **URL:** \ **Category:** Get Help\ **Tags:** Google-Sheets-Writer\ **Created:** [March 5, 2025, 4:17pm UTC](https://forum.gumloop.com/t/extract-to-table-is-failing-for-google-sheets/1704 "2025-03-05T16:17:26Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Parag](https://avatars.discourse-cdn.com/v4/letter/p/a5b964/32.png) [@Parag](https://forum.gumloop.com/u/Parag)\ **Post date:** [March 5, 2025, 4:17pm UTC](https://forum.gumloop.com/t/extract-to-table-is-failing-for-google-sheets/1704/1 "2025-03-05T16:17:26Z")
I am getting the following error even though I have given editor permission on my google sheet. ![image](https://canada1.discourse-cdn.com/flex027/uploads/gumloop/original/1X/484d859905e48f655786a99a5ee71c1184264f77.png) [https://www.gumloop.com/pipeline?workbook\_id=smC8rErK9x7DRYjQcRswPN&run\_id=etVxuRHZFZZXnPi3jHiTjB](https://www.gumloop.com/pipeline?workbook_id=smC8rErK9x7DRYjQcRswPN&run_id=etVxuRHZFZZXnPi3jHiTjB) ---
**Author:** ![Gumloop\_Bot](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.gumloop.com/gumloop_bot/32/504_2.png) [@Gumloop\_Bot](https://forum.gumloop.com/u/Gumloop_Bot)\ **Post date:** [March 5, 2025, 4:17pm UTC](https://forum.gumloop.com/t/extract-to-table-is-failing-for-google-sheets/1704/2 "2025-03-05T16:17:29Z")
Hey @Parag! If you’re reporting an issue with a flow or an error in a run, please include the **run link** and make sure it’s **shareable** so we can take a look. 1. **Find your run link** on the history page. Format: `https://www.gumloop.com/pipeline?run_id={your_run_id}&workbook_id={workbook_id}` 2. **Make it shareable** by clicking **“Share”** → ‘Anyone with the link can view’ in the top-left corner of the flow screen. ![GIF guide](https://canada1.discourse-cdn.com/flex027/uploads/gumloop/original/1X/92c00c612fd65b861e706dd1b5eec5ec61677835.gif) 3. **Provide details** about the issue—more context helps us troubleshoot faster. You can find your run history here: [https://www.gumloop.com/history](https://www.gumloop.com/history) ---
**Author:** ![Wasay-Gumloop](https://yyz1.discourse-cdn.com/flex027/user_avatar/forum.gumloop.com/wasay-gumloop/32/69_2.png) [@Wasay-Gumloop](https://forum.gumloop.com/u/Wasay-Gumloop)\ **Post date:** [March 6, 2025, 4:19am UTC](https://forum.gumloop.com/t/extract-to-table-is-failing-for-google-sheets/1704/3 "2025-03-06T04:19:48Z")
Hey @Parag - The Extract to Table node uses [OpenAI’s structured JSON](https://platform.openai.com/docs/guides/structured-outputs) output to extract data which seemed to have timed out here. I’d recommend using an `Extract Data` node and then connecting the data fields with the `Google Sheet Writer` node. The Extract Data node allows you add specific prompts for each data field and you can play around with different AI models. Here’s a guided tutorial on `Extract Data` + `Google Sheet Writer` node: [https://www.gumloop.com/pipeline?workbook\_id=dthCiSMZQ4XSfKe5CtHNBX&tutorial=true&guided\_tutorial\_id=web\_scraping](https://www.gumloop.com/pipeline?workbook_id=dthCiSMZQ4XSfKe5CtHNBX&tutorial=true&guided_tutorial_id=web_scraping) I’d also recommend looking into subflows to make your flow clean and more manageable. **Subflow Tutorial:** [https://vimeo.com/1052111235/cb7e3a446b](https://vimeo.com/1052111235/cb7e3a446b) **Subflow Docs:** [https://docs.gumloop.com/core-concepts/subflows](https://docs.gumloop.com/core-concepts/subflows) Let me know if this works for you. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex027/uploads/gumloop/original/1X/d02ff8efcde6ac5d3ac8aa0376137d5f804da549.png) [@system](https://forum.gumloop.com/u/system)\ **Post date:** [March 11, 2025, 4:20am UTC](https://forum.gumloop.com/t/extract-to-table-is-failing-for-google-sheets/1704/4 "2025-03-11T04:20:28Z")
This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.