Question

Reply ends up on the next following row - why?


I have a Zap where i use GPT to analyze an image.

  1. Trigger, updated row in google Sheet

     

  2. Task: Describe image
  3. Done: Update the same row, I´m using the same Row ID as in the first step.

 

Whats wrong? The summary ends up on the next row. So if the image is at row 981, the summary ends up at 982.

I can see in the input/output that it ends up one the next row, but can not understand why. 

 

In the file:
 

In the Output:

 


12 replies

Userlevel 7
Badge +14

Hi @midorimiab 

Show screenshots of the DATA IN tab from the same Zap Run where it updates the GSheet row.

For a Zap Run, best to show screenshots of the DATA IN/OUT for each step so the data flow can be traced across steps.

 

Hi Troy and thabks for the help. 
 

Here us the in/out for all steps:
 

 

Userlevel 7
Badge +14

@midorimiab 

That Zap Run example was triggered by row 7 and updated row 7.

That appears to be working as expected to update the row that triggered the Zap.

@Troy Tessalone 

 

Thank you for the reply. 

 

The issue is that the image that is described is on the row above. If you see in my first post image, 2149, appears on row 6, but the output comes out at row 7. 

It feels like the issue is in the first step of the zap, butI can not understand what. 

 

 

 

 

 

@Troy Tessalone

 

Thank you for the reply. 

 

The issue is that the image that is described is on the row above. If you see in my first post image, 2149, appears on row 6, but the output comes out at row 7. 

It feels like the issue is in the first step of the zap, butI can not understand what. 

 

 

 

 

 

Hi @Troy Tessalone , or anyone else.

 

Any other ides why the rows gets mixed up?
All help is highly appreciated!

Userlevel 7
Badge +14

@midorimiab 

From the screenshots for your specific Zap Run example, the row that triggered the Zap to run was Row 7.

Then in Step 4, the Zap updated the same Row 7, so the Zap is working to update the same row that triggered the Zap to run.

I recommend checking other Zap Runs to see the row IDs used in the Zap steps as that is the actual data that was processed by the Zap.

 


The part that gets wrong is initially, the actual image that is analyzed is not on row 7, its on row 6. The same goes for any image in the document. 

 

This is how it looks:

 

In the file, image 2145 occurs on row 6:
 


The description of this image, no 2149, ends up in row 7. The row below. 

 

So for each image, 1500 reads in the sheet. With 15+ columns of metadata if the product, the title and summary of the product image end up on the wrong row. 

Userlevel 3
Badge +3

Hi @midorimiab Would it be an issue with the header? And what is the “trigger column” you used for Step 1? 

Hi @fiona819 and @Troy Tessalone 

I've tried all the tips and tricks, but nothing seems to work. Would anyone be available for a short Teams or Zoom session where I can share my screen? I'm happy to pay for your advice and time.

 

 

Userlevel 7
Badge +14

@midorimiab 

If you are looking to hire help, check the directory of Certified Zapier Experts: https://zapier.com/experts

@midorimiab

If you are looking to hire help, check the directory of Certified Zapier Experts: https://zapier.com/experts

Thanks, I had a look there before, but it seems like all options are project-based with a minimum spend. I just need someone to have a quick look at my zap and identify the mistake. But I will keep looking. 

 

 

Userlevel 7
Badge +14

@midorimiab 

Perhaps record and share a Loom.com video link that shows more context about your Zaps and Zap Runs.

Reply