Google Sheets Update Error

Get Help
1

I’m having trouble running this pipeline where the data seems unable to update on to google sheet.

It says No Search Value found.

→ I’ve tried many different search value and none work, i’m not sure what is the accurate search value to key in here

https://www.gumloop.com/pipeline?workbook_id=cBHG1kfHTW6StxZSoHN1vf&run_id=K4DSfyxz5jrqLazPF97Fu9

2

Hey @tamnguyen! 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 @tamnguyen – The Google Sheet Updater node is used when you want to update existing rows in a spreadsheet, while the Google Sheet Writer node is meant for adding new rows. What are you looking to accomplish here?

If you want to update existing rows using the Sheet Updater node, you’ll need to provide both a search value and a search column. These are necessary to locate the specific row you want to update, so make sure the values actually exist in your sheet.

For example, if your sheet has three columns:

  • ID
  • Product Name
  • Product Description

If your goal is to update the Product Name and Description for existing product IDs, then the ID should be provided as the search value.

You can find more info on the Sheet Updater node here.

And here’s the link for the Sheet Writer node.

Let me know if this clears things up!

4

Yes i change Google Sheet Writers and it works now.
However the column imported seems to be incorrect (1 col in despite my choice)
My column is:
KEYWORD | TITLE | ARTICLE | IMAGE
Data fill in at:
KEYWORD [NO DATA] | TITLE [KEYWORD INFO] | ARTICLE [TITLE INFO] | IMAGE [ARTICLE INFO]

Any suggestion to fix this?

5

Not sure if I follow but would you be able to share the run link from the https://www.gumloop.com/history page so I can take a closer look please?

Also, please set the share access in the workbook to “anyone with the link can view” from the share button.

image
image1378×710 22.6 KB

6

You’ll need to see my Google sheet as well to understand.

Here’s the flow: https://www.gumloop.com/pipeline?workbook_id=cBHG1kfHTW6StxZSoHN1vf

Here’s the sheet: https://www.gumloop.com/pipeline?workbook_id=cBHG1kfHTW6StxZSoHN1vf

7

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