Google sheet updater fail - New to Gumloop

Get Help
1

Google sheet updater failed, appreciate any guidance

https://www.gumloop.com/pipeline?workbook_id=aASmL1gsKS2qt6V62J7313

2

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

link share https://www.gumloop.com/pipeline?workbook_id=aASmL1gsKS2qt6V62J7313

4

history : https://www.gumloop.com/pipeline?run_id=j35dtTndBwFDy93RuUR4H7&workbook_id=aASmL1gsKS2qt6V62J7313

5

Hey @Birdie – You should disable Loop Mode on the Website Scraper and Extract Data node since you’re only scraping a single website here. Try this link: https://www.gumloop.com/pipeline?workbook_id=nncMx593nCVdCVqPHfZZA8

6

Thanks still got the google sheets error below

image
image499×543 27.3 KB

7

Hi @Wasay-Gumloop, thank you for your reply , now it’s working for me , but i have a question , how to tell the automation to go to next page ?

8

I got it working by adding the columns I wanted into google spreadsheet line 1

I now need to move to multiple pages

Extract part number from description which is stored in the brackets and

Change to Ex VAT pricing

9

Pagination depends on the site, you can extract all links using the Website Crawler and run the flow in loop mode. Loop Mode - Gumloop

Or you can append page numbers in the base URL, more on that here: Webscraping multiple Trustpilot pages for reviews - #4 by Wasay-Gumloop

1 Like
10

Hey, getting a failed sheets node. All columns are present and data is extracted successfully - https://www.gumloop.com/pipeline?workbook_id=dthCiSMZQ4XSfKe5CtHNBX&tutorial=true&guided_tutorial_id=web_scraping&run_id=XgUGNTYwygDEdPBhheyPxx

11

Hey @conbon – Could you please revoke & re-authenticate with Google Drive & Google Sheets here: https://www.gumloop.com/settings/profile/credentials

Once you’ve done that please remove the Google Sheet Writer node, add it back and run the flow. Let me know if that works.

12

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