Google sheet updater error, using freshly created sheet from sheet writer

Get Help
,
1

The goal of this workflow is to put purchase order (PO) information in a new google sheet file, named after the PO number, by analyzing the PO pdf, Then extracting some information from images that relate to the purchase order and update the created google sheet with the information extracted from the drawings. everythings seems to be working. a new shete is created and i use the link to that sheet as an input of my google sheet updater node, but i get an error with out much explanation that the google sheet updater failed. How do i fix this problem? to be clear, i want to create a new google sheet file and update that file in the same workflow to eventauly send it of via an e-mail.

any other suggestions on how to achieve this wold also be helpfull, thankyou in advance.

gumloop link: https://www.gumloop.com/pipeline?workbook_id=8Si3xQZiS4uoBWk2VirQM3&tab=1&run_id=5JFdbUtGPMx2J4LCDTELzp

google Sheet link ( created by gumloop): https://docs.google.com/spreadsheets/d/1GUGYSIz4cIFeItr1JllCq8kgJrH_T9jmpUDywD0LYMA/edit?usp=sharing

google sheet link ( baseline sheet): https://docs.google.com/spreadsheets/d/1B1ymBt1WXij2bVNAyAfdKgDxYitfubXkLE4kRzloYhs/edit?usp=sharing

2

Hey @Donna! 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

  3. Provide details about the issue—more context helps us troubleshoot faster.

You can find your run history here: https://www.gumloop.com/history

3

Hey @Donna – Do you mind sharing access to the run link by adding my email (wasay@gumloop.com) through the share button please?

It would also be great if you could share access to the spreadsheets but of course not necessary!

4

Just shared all.

Thanks

5

Thank you @Donna – The fix here would to enable Loop Mode on the Google Sheet Updater node and change Update Multiple Rows to Update a Single New Row.

This lets each row run in its own loop iteration – essentially a separate API call to Google Sheets – which is necessary because we’re passing multiple sheet links dynamically.

Example run: pipeline

Let me know if this makes sense and works for you :slightly_smiling_face:

6

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.