Google Update thing

Get Help General Question
,
1

So I know how to use Google Sheet Update. You have a search value which you connect to the Google Sheet so the Update node knows where to include the update.

  1. But in my case I have a pdf with items. Every item has a number.
  2. Next to that I have a google sheet with items (and numbers) and certain parameters per item (length and width).

In the pdf (path 1.) I have the weight of each item.

In a seperate flow I’m able to extract the weight and number via Analyze Image node.

Now the question:

How do I use Google Sheet Update in this flow? I do not have a reference for the Search Value in this flow … What I do have it the item number (from the pdf). I tried to use that as the reference number … but without luck …

Hope you understand my problem

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

See the flow here - https://www.gumloop.com/pipeline?workbook_id=8Si3xQZiS4uoBWk2VirQM3&tab=1&run_id=cnczQLGW45rnAejKXnVPrb

4

Hey @Donna — this is a really interesting use case. Just to make sure I understand it correctly: you’ve got a spreadsheet with existing product info, and you’re looking to update that with additional data extracted from a PDF, right?

Can something like the product name be used as a reliable search value?
Item number could also work — but does the item number you’re passing into the node actually exist in the spreadsheet?

Also noticed you’re using the item number from the Find & Replace node as the search value instead of the one from the Extract Data node — does the formatting match what’s in the spreadsheet?

One more thing: your search column is set to Article Nr — just confirming that’s the correct column for item numbers?

If none of those options work reliably, it might be simpler to write the new data to a separate tab instead of updating the existing sheet. Even with a working search value, if it’s AI-generated, there’s always a chance it won’t match exactly — and the updater node will error out in that case.

5

@Wasay-Gumloop see below my answers:

Hey @Donna — this is a really interesting use case. Just to make sure I understand it correctly: you’ve got a spreadsheet with existing product info, and you’re looking to update that with additional data extracted from a PDF, right?

That is correct

Can something like the product name be used as a reliable search value?
Item number could also work — but does the item number you’re passing into the node actually exist in the spreadsheet?

Yes, that is what I tried, to use the item number as a reliable search value. (you helped me yesterday with the re-writing of the number)

Also noticed you’re using the item number from the Find & Replace node as the search value instead of the one from the Extract Data node — does the formatting match what’s in the spreadsheet?

In the spreadsheet I see this, the number with some dots:

image
image1312×382 32.1 KB

From the pdf is get this, the number without the dots:

image
image1418×640 22.8 KB

(which we then “rewrote” in the same format as the spreadsheet number

One more thing: your search column is set to Article Nr — just confirming that’s the correct column for item numbers?

Here you see the column’s. In black is what I have, in Red is what should come from the pdf

image
image4512×338 65.1 KB

If none of those options work reliably, it might be simpler to write the new data to a separate tab instead of updating the existing sheet. Even with a working search value, if it’s AI-generated, there’s always a chance it won’t match exactly — and the updater node will error out in that case.

A good plan B … But maybe we can try to solve this as a plan A and have the community also benefiot from this.

But you are the boss … :wink:

6

Great, thanks for the details! This looks possible—just two quick notes:

  1. I noticed the column name for the item number is Drawingnumber. On the run link, it seems to be set to something else. Could you refresh that and select the correct column?

image
image2102×1404 228 KB

  1. The search value coming from the Find & Replace node is 5.000.01.6900, but your sheet has 5.000.00.16900. The values need to match exactly. Since the AI is extracting the number, you’ll want to give it clear instructions to pull the correct format—and make sure the format in the Find & Replace node matches the spreadsheet exactly.
7

Ok will give it a shot

Will keep you updayted

1 Like
8

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