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!
Thank you! I’m viewing the run now but I don’t see any rows skipped by the sheet writer node. Could you elaborate your issue a bit more, ideally with screenshots please?
There are 10 inputs to the Discount column passed directly from the Extract Data node all of which are written to the sheet:
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
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.
