Hey, Issac/ ​@TepatWork!

Could you send a screenshot of your Google Sheet Action? There's a huge chance that the problem lies there.

For example, this is how it must look to work as yuo expect:

• You'll use the Update Row action
• The Lookup Column acts as an ID. And this must be stored to the contact in some Custom Field or you use some system field to use as ID (in the image below, I have a column called IG_User that receives the Instagram username (if no exists) or updates the corresponding columns (if it exists).
  • I don't see something that works like an ID in your table.

Following this logic, it should work and update the data instead of always creating new lines.

Hope this helps!

Hi Fabio,

@fabio.gaulke

Thanks for jumping on to help me with this. I believe I implemented your changes correctly, and yet the problem persists. I seem to be missing something. As requested, here’s a screenshot of my Google Sheets Action. This is an updated version of the Google Sheets Action, based on your suggestion. I’ve also attached my flow, so you can see what I’ve done; and perhaps I’ve misused the function.

As well, you will note that my spreadsheet now has a “oWorker - ID]” column. This was in response to your mention for the necessity for an ID on the table, but it has only blank cells with no formatting.

Finally, the problem with “ Worker - Experience]” not being added to the spreadsheet persists, and I’m at a loss as to why.

Please forgive such a long response, I’m still trying to wrap my head around how this program works.

Thanks again in advance,

Isaac

I figured it out. Thank you very much for your assistance.

Hi, ​@TepatWork!

Glad you've got it working!

The problem was here:

The Lookup Value will be used to search if it exists in the Lookup Column.

In this case, it was looking for the Workers Location at the Workers Name column.