Connecting Google Sheets

[Hiking_Techie]

Hello,

I am trying to connect two google sheets to ensure that once someone updates the status as sold, the item is removed in the next google sheet. The run is having issues at the join paths point and i can’t seem to understand the assistance offered by Gummie.

Here is the Fail Run Code ID- https://www.gumloop.com/pipeline?workbook_id=1v6gTpMdLrYzdyVbKrvHbr&run_id=ahJb2DuDsiWJC9bx26TpwN.

Below is the solution that Gummie is providing and I am truly lost.

[Wasay-Gumloop]

Hey @Hiking_Techie - There does not seem to be any inputs connected to the Join Paths node in your run.

You can learn more about how the node works along with some sample workflows here: https://docs.gumloop.com/nodes/flow_basics/join_paths

Let me know if this makes sense and works for you.

[Flownir]

Hi, I have recreated all this, and luckily I was successfull in creating all this.

I have not used the loops here, but to make things simpler, I used this simple process:
Google Sheet Reader > Combine Text > Filter > Extract Data > Google Sheet writer

This is done with the help of filters, if status si set as Sold, then the data will go next and proceed further. This is too easy to understand and it’s working perfectly.

Here is the short YouTube Video, If you want to understand all this:

2 Google Sheets | If 1st g-sheet status is updated, the Data should go to 2nd sheet Automatically

Looking to set up your own automation in Gumloop? If anyone need help with automating workflows, feel free to reach out! Let’s build something amazing together.

Contact me: sarimportfolio@gmail.com

[Hiking_Techie]

Thank you Wassay and Flownir, this was so helpful and it actually worked. For further assistance, I am reaching out via email to you Flownir.

Have a great day/evening!

[Flownir]

You’re welcome! I’m glad it worked for you. Feel free to reach out via email, and I’ll be happy to assist further.

Have a great day/evening too!