Hello all,
Does anyone know how to automate calculations using the Google-Sheets-Writer? In the example I’m working with, I have two columns (Cost and Sub-Total). From these two columns, I need to calculate the Discount. When I copy the formula down (as Gummie suggested lol) the google sheets writer skips these rows because it thinks there is data in the cells that say $0.00.
Has anyone dealt with something similar to this?
Thank you!
Hey @JarredRobidoux - Can you please share the run link from the history page with share access enabled (you can set the link to ‘anyone with the link can view’) so I can understand the use-case properly?
Wasay,
Here is the run link
https://www.gumloop.com/pipeline?run_id=Bq2fgEMy6QqaPTGj4AabRc&workbook_id=dceTvNsarMquagNTK9psvy
I’ve requested access to view the flow. You can also enable ‘anyone with the link can view’ under the share button.
just gave you access!
Ah yes - apologies Wasay.
Here is a screenshot from the Google Sheet we are writing to:
Right now we are using a manual formula to return the correct discount. If you look at the screenshot you provided, you can see the Extract Data node hallucinates a bit and returns the wrong value. This Discounts column should be (Sub-Total - Cost) to return the difference.
Currently, I am using the context provided in the Extract Data node to try and explain this - which I think might be where it’s returning some errors.
Let me know if this makes sense, or if you have anymore questions.
Thank you!
Ah I see. I don’t think you need to add the discount data field in the Extract Data node then since its just a simple formula. You can dynamically add the forumla in a Combine Text node and then write to the Google Sheet.
Here’s an example: https://www.gumloop.com/pipeline?workbook_id=tnDCXhHN25hERhgv8YHePg&run_id=oH9LcRgponAfCKNZ9JkNTB
Google Sheet: Macron Flow <> Forum - Google Sheets
Let me knwo if that is what you were looking for.
Wasay,
Thank you! This is exactly what I was looking for.
One last question, once you finish creating a flow, how do you push it into production?
Thanks again for all your help!
No problem!
Could you elaborate a bit on what you mean by pushing a flow in production? By default all workflows are in an ‘active’ state meaning they can be run anytime. However if you mean’t adding a trigger to the workflow, you should refer to this documentation: Triggers - Gumloop
Let me know if that is what you were looking for.
Ahh okay.
So in the case where I built this flow for someone else, they would have to create a gumloop account and connect their google sheets in order for the flow to start? There’s no way for the trigger to just constantly be on right?
I’ll take a look into the documentation you set
Thanks again!
Yes that is correct, they’ll need to have a Gumloop account and the necessary credentials here: https://www.gumloop.com/settings/profile/credentials
