Update data in GoogleSheets

Hello, good afternoon,

I’m having difficulties updating a spreadsheet on Make.com. Every time I try to update the data within the spreadsheet, it ends up creating new rows instead of updating the existing ones. I am new to the platform and set up the workflow as follows:

Updating about the issue.

I managed to adjust it so that it updates the spreadsheet, but it keeps updating the information in just one row.
I would like assistance in making it go line by line updating the information.

Welcome to the Make community!

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes

Hello,
I made some modifications to the workflow, but I’m facing the following issue:

It’s not adding clients to the spreadsheet, and consequently, it’s not updating the information.

blueprint.json (1016.8 KB)

Without the update row, it’s adding without any problems.
If I link the update, it goes back to the previous problem…

Hi @samliew ! I have a very similar question to @Cataratas_Net.

I am attempting to get a SQL queries (from my our ERP using Microsoft SQL Server or MySQL) to export to a CSV (excel) which will then update a Google Sheet (ideally in different tabs for each product category within the one sheet). The SQL query can pull different classes of customers and product categories which I would like to use to sort and route/update tabs. It could be many product categories to one tab.

The goal is to update a pricing list broken down by product category to different customers on a daily basis using the SQL query from our ERP.

I have reviewed some of the support materials (ex running email to sheets), but am struggling with the scenarios and what needs to happen to get the automations to run. I have already researched out to the customer service team, but have not yet heard back.

Could you please provide me with materials / instructions on how I could get such a scenario running?

Thank you!

Hello @lisah welcome to the community :wave:

I’m just stepping in to share a friendly piece of advice.

In the community, it’s generally more effective to start a fresh topic for each new question rather than commenting on existing threads. When you start a new conversation, you’re more likely to catch the community’s attention and receive the help you need.

Thanks for helping to keep the community organized and making it easier for everyone to share and find the information they need. :pray:

1 Like

Hello @Michaela do you think I should make another post as well? After all, it’s been 1 month since I’ve had the issue, and no one has come up with any suggestions…
I’ve tried various ways to solve it, and I would really appreciate some help in finding a solution.

Hey there @Cataratas_Net ! I don’t have the full context but it seems to me you’re likely mapping something in the Search module that is causing the same row to always be output.

But I’m missing some stuff here to be sure or suggest any kind of solution too.

  1. Can you show us the output of module 150?
  2. Is there data from any other module being mapped to the sheets as well?
  3. Could you also please describe what exactly you want to do? Do you intend to create new rows when a certain item does not exist? Or are you trying to always just update rows?
  4. Lastly, how are you searching for the rows in module 163? Can you show us a screenshot of the module mappings?

Thanks!