A: Hi thanks for your question. Yes, you can send out an email when a customer fills in a Google Form, and the email will be sent out instantly with the template you have set up. However, it is not possible to schedule further emails at another time.
Q: Conditional Copying and sending of rows to other sheet.
Hi there!
Can Logic Sheet create an automation, that:
1) When Cell contains "X", then row is copied to Sheet B. When Cell Contains "Y", then Row is copied to Sheet C. etc... 2) Can Logic Sheet Delete Rows, when two rows have the same identifier, then the older gets deleted?
Last but not least: Which feature is or will be the coolest one, from your perspective as product owner/developer?
1. Yes this is possible with the copy to sheet action, you need to set a condition to each move to sheet action. 2. Yes, this can be done with the remove duplicate action. For the last question, I believe is the HTTP reqeust action which allows you to talk to almost any API and send data to third party services when an automation is triggered. We also have a built...
A: Hi, yes, you can run one type of trigger in each sheet. So you can crate one webhook trigger, one edit trigger, one time-based trigger, and one form submission trigger in one spreadsheet.
A: Hi, yes, you can set up multiple actions with one trigger. In each action you can even set a condition for when it should run so every thing is controlled in a fine-grained way.
Hi, I'd like to double check it before I buy it. The cheapest option is "For 1 Google Sheets account". Is it for one sheet document only or one account (many sheets)? Thank you
A: Hi thanks for the question. The tier 1 license allows you to use Logic Sheet in unlimited spreadsheet documents in one Google account. There is no limit how many documents you use it in.
Q: Google Form/Google Sheets & E-mails
Hi there!
Can Logic Sheet help to automate sending of e-mails?
i.e. If a customer fills up a Google form, this gets brought into google sheets, which triggers a customised e-mail being sent out via gmail.
Can we also then customise an entire workflow to send different emails at different times?
i.e. Email ONE sent out upon filling up form, email TWO sent out again 3 days later, email THREE sent out five days later.
Wei_Sheng
Dec 1, 2024A: Hi thanks for your question. Yes, you can send out an email when a customer fills in a Google Form, and the email will be sent out instantly with the template you have set up. However, it is not possible to schedule further emails at another time.
Share Logic Sheet - Google Sheets automation
Q: Conditional Copying and sending of rows to other sheet.
Hi there!
Can Logic Sheet create an automation, that:
1) When Cell contains "X", then row is copied to Sheet B. When Cell Contains "Y", then Row is copied to Sheet C. etc...
2) Can Logic Sheet Delete Rows, when two rows have the same identifier, then the older gets deleted?
Last but not least:
Which feature is or will be the coolest one, from your perspective as product owner/developer?
Thanks.
Wei_Sheng
Dec 1, 2024A: Hi thanks for your question.
1. Yes this is possible with the copy to sheet action, you need to set a condition to each move to sheet action.
2. Yes, this can be done with the remove duplicate action.
For the last question, I believe is the HTTP reqeust action which allows you to talk to almost any API and send data to third party services when an automation is triggered. We also have a built...
Share Logic Sheet - Google Sheets automation
Q: Can you run multiple triggers on the same sheet?
i.e. send a webhook when a row gets created and then send another webhook when a cell is updated...
Thanks!!!
Wei_Sheng
Nov 25, 2024A: Hi, yes, you can run one type of trigger in each sheet. So you can crate one webhook trigger, one edit trigger, one time-based trigger, and one form submission trigger in one spreadsheet.
Share Logic Sheet - Google Sheets automation
Q: 2 automations (or more) for a new row?
When a new row is added, is it possible to activate 2 automations? One to send an email, one to Encharge for example?
Wei_Sheng
Nov 22, 2024A: Hi, yes, you can set up multiple actions with one trigger. In each action you can even set a condition for when it should run so every thing is controlled in a fine-grained way.
Share Logic Sheet - Google Sheets automation
Q: Purchase question
Hi, I'd like to double check it before I buy it. The cheapest option is "For 1 Google Sheets account". Is it for one sheet document only or one account (many sheets)? Thank you
Wei_Sheng
Nov 22, 2024A: Hi thanks for the question. The tier 1 license allows you to use Logic Sheet in unlimited spreadsheet documents in one Google account. There is no limit how many documents you use it in.
Share Logic Sheet - Google Sheets automation