I'm trying to connect a google sheet as a trigger (new row added). The system recognizes the Trigger events, as I can see the raw data on the workflow summary screen, however it does not show the specific column headings or data when editing the workflow. The View Triggers and Variables only shows the generic "column 1" "column 2" etc. I'm hoping there is an easy solution to this as this will dramatically help me manage my lists in SendFox
Q: A couple of questions:
1) Can I remove duplicate entries?
2) I have one spreadsheet with about 1,000 websites listed, and I add to it. Is there a way to alert me before I add a duplicate website? thanks :)
Founder Team
Brutuz_SheetAutomation
May 15, 2024
A: Removing duplication is not a built-in action yet, but it's on our roadmap. At the moment, some users are using sheet formula (COUNTIF) + sheet automation to implement duplication detection and perform actions accordingly. Feel free to drop me an email.
Q: Hello,
I would like to know if this app can handle several rules conditions for one row input.
For example: I have a column (field) Name. A name with "Donald, Mario, Ronald". The rule will check if column "Name" contains "Donald", it would send an entire row to "Donald sheet". Next row, if it contains "Mario", it would send an entire row to "Mario Sheet". Can it be possible? Because currently, I only saw that I can only processed the first rules only. Or what I am missing?
Founder Team
Brutuz_SheetAutomation
May 15, 2024
A: This should be pretty easy to achieve. See this recipe: https://sheetautomation.com/docs/recipes/move-copy-row/#how-to-distribute-rows-to-multiple-sheets-based-on-column-value
Q: Can this turn google sheets into an api like sheetly or sheetdb or nocodeapi
Lastly can I automate api calling?
Founder Team
Brutuz_SheetAutomation
May 15, 2024
A: Hi ritchcuvier,
Turning sheet into API is not supported. I'm not sure if this is something we'll do in the long run. As for API calling, you can call webhook endpoint at the moment. Supporting arbitrary HTTP API/method is on the roadmap.
Q: Does this offer an easy way for people to do import range.
If not please do it asap.
Founder Team
Brutuz_SheetAutomation
May 15, 2024
A: Hi ritchcuvier,
Could you provide more details on your use case? Sheet Automation aims to do something that google sheets are not good at, but not everything. ImportRange seems to be working well unless you have very special requirements.
Q: Is this tool still being supported?
I'm trying to connect a google sheet as a trigger (new row added). The system recognizes the Trigger events, as I can see the raw data on the workflow summary screen, however it does not show the specific column headings or data when editing the workflow. The View Triggers and Variables only shows the generic "column 1" "column 2" etc. I'm hoping there is an easy solution to this as this will dramatically help me manage my lists in SendFox
Share Sheet Automation for Google Sheets
Q: A couple of questions: 1) Can I remove duplicate entries?
2) I have one spreadsheet with about 1,000 websites listed, and I add to it. Is there a way to alert me before I add a duplicate website?
thanks :)
Brutuz_SheetAutomation
May 15, 2024A: Removing duplication is not a built-in action yet, but it's on our roadmap. At the moment, some users are using sheet formula (COUNTIF) + sheet automation to implement duplication detection and perform actions accordingly. Feel free to drop me an email.
Share Sheet Automation for Google Sheets
Q: Hello, I would like to know if this app can handle several rules conditions for one row input.
For example: I have a column (field) Name. A name with "Donald, Mario, Ronald".
The rule will check if column "Name" contains "Donald", it would send an entire row to "Donald sheet".
Next row, if it contains "Mario", it would send an entire row to "Mario Sheet".
Can it be possible? Because currently, I only saw that I can only processed the first rules only. Or what I am missing?
Brutuz_SheetAutomation
May 15, 2024A: This should be pretty easy to achieve. See this recipe: https://sheetautomation.com/docs/recipes/move-copy-row/#how-to-distribute-rows-to-multiple-sheets-based-on-column-value
Share Sheet Automation for Google Sheets
Q: Can this turn google sheets into an api like sheetly or sheetdb or nocodeapi Lastly can I automate api calling?
Brutuz_SheetAutomation
May 15, 2024A: Hi ritchcuvier,
Turning sheet into API is not supported. I'm not sure if this is something we'll do in the long run. As for API calling, you can call webhook endpoint at the moment. Supporting arbitrary HTTP API/method is on the roadmap.
Share Sheet Automation for Google Sheets
Q: Does this offer an easy way for people to do import range.
If not please do it asap.
Brutuz_SheetAutomation
May 15, 2024A: Hi ritchcuvier,
Could you provide more details on your use case? Sheet Automation aims to do something that google sheets are not good at, but not everything. ImportRange seems to be working well unless you have very special requirements.
Share Sheet Automation for Google Sheets