A: Hi, Logic Sheet is being actively maintained and constantly updated, all of it's features are functioning and we are supporting all existing and new users. These changes are not reflected on the roadmap but it doesn't mean our product is not updated. Let me know if you have mroe questions!
Hi, I am trying to create an automatization to send an email if there are 3 days to a value date in a column, however I am continuously receiving an error message. 1. Is this possible? 2. can we reference range of cell's value with a tag?
I would like to verify if any value in a cell range is met as a condition to trigger an emai.
A: Hi, you can use the merge tags listed here https://help.logicsheet.co/automation/merge-tags. you can use merge tags like {{triggering row N value}} and {{range A1}} to refer to dynamic values in Google Sheets. However, it is not possible to send an email 3 days before a date, all automations are concurrent to the trigger event.
Can I reference another sheet to pull data from to draft an email? Can I also reference other cells to draft an email that includes text from another reference cell?
A: Hi, currently the automation will only be able to reference data in the spreadsheet that it runs in. If you want to reference other spreadsheets, you need to use the importrange function to import the data first, then it can be referenced in Logic Sheet.
Is logic sheet similar to Make.com whereby I can connect 2 or more Apps using their API's? Or the connection has to do with importing data into Google sheets for it to work? For example, I have a payment system that I will like to connect to an inventory management system to update quantities when payments are made, will that work in logic sheet by connecting both API's?
A: Hi, thanks for your question! Logic Sheet is primarily focused on automating tasks within Google Sheets. It allows for integrating with external applications via HTTP requests, meaning you can send data from Google Sheets to other systems. However, it's not specifically designed like Make.com to connect multiple apps directly through their APIs beyond the context of Google Sheets.
I shadow invoice on G sheets, to track my hours. Then at the end of the month, I log onto my client's website, to actually bill for the hours. The client then generates a Paid Receipt, and deposits money into my account. My question is, can this add on automate this: log into my client's website where it generates the Paid Invoice, and then be downloaded back into my G Sheets, to be reconciled against my shadow invoice, to be sure I was paid the correct amount? I have 10+ client each month, and I find this process tedious.
Extra ask, can the same Add On log into my bank (or I can upload the CVS from my bank account), then automatically double check that the actual correct corresponding deposit has occurred?
I hope I made sense... Much thanks!! Wen from Canada
Regarding your second question about reconciling financial data and invoices, currently, Logic Sheet does not have the capability to autonomously reconcile financial data by logging into your bank or directly pulling data from external financial systems or websites. The reconciliation processes you described would typically require more sophisticated...
Q: Roadmap is Out of date
Hi, I was thinking about upgrading but, it seems as if the roadmap hasn't been updated.
Seems as if the app isn't being updated.
Wei_Sheng
Jan 27, 2025A: Hi, Logic Sheet is being actively maintained and constantly updated, all of it's features are functioning and we are supporting all existing and new users. These changes are not reflected on the roadmap but it doesn't mean our product is not updated. Let me know if you have mroe questions!
Share Logic Sheet - Google Sheets automation
Q: Value in Column condition
Hi,
I am trying to create an automatization to send an email if there are 3 days to a value date in a column, however I am continuously receiving an error message.
1. Is this possible?
2. can we reference range of cell's value with a tag?
I would like to verify if any value in a cell range is met as a condition to trigger an emai.
Wei_Sheng
Jan 27, 2025A: Hi, you can use the merge tags listed here https://help.logicsheet.co/automation/merge-tags. you can use merge tags like {{triggering row N value}} and {{range A1}} to refer to dynamic values in Google Sheets. However, it is not possible to send an email 3 days before a date, all automations are concurrent to the trigger event.
Share Logic Sheet - Google Sheets automation
Q: Automation Question
Can I reference another sheet to pull data from to draft an email?
Can I also reference other cells to draft an email that includes text from another reference cell?
Wei_Sheng
Jan 14, 2025A: Hi, currently the automation will only be able to reference data in the spreadsheet that it runs in. If you want to reference other spreadsheets, you need to use the importrange function to import the data first, then it can be referenced in Logic Sheet.
Share Logic Sheet - Google Sheets automation
Q: Logic sheet and API's
Is logic sheet similar to Make.com whereby I can connect 2 or more Apps using their API's? Or the connection has to do with importing data into Google sheets for it to work? For example, I have a payment system that I will like to connect to an inventory management system to update quantities when payments are made, will that work in logic sheet by connecting both API's?
Wei_Sheng
Jan 3, 2025A: Hi, thanks for your question! Logic Sheet is primarily focused on automating tasks within Google Sheets. It allows for integrating with external applications via HTTP requests, meaning you can send data from Google Sheets to other systems. However, it's not specifically designed like Make.com to connect multiple apps directly through their APIs beyond the context of Google Sheets.
For your use...
Share Logic Sheet - Google Sheets automation
Q: Can below user case be solved by Logic Sheet?
Hi, I am a small business owner in healthcare.
I shadow invoice on G sheets, to track my hours. Then at the end of the month, I log onto my client's website, to actually bill for the hours. The client then generates a Paid Receipt, and deposits money into my account. My question is, can this add on automate this: log into my client's website where it generates the Paid Invoice, and then be downloaded back into my G Sheets, to be reconciled against my shadow invoice, to be sure I was paid the correct amount? I have 10+ client each month, and I find this process tedious.
Extra ask, can the same Add On log into my bank (or I can upload the CVS from my bank account), then automatically double check that the actual correct corresponding deposit has occurred?
I hope I made sense...
Much thanks!!
Wen from Canada
Wei_Sheng
Jan 3, 2025A: Hi Wen,
Thanks for your questions!
Regarding your second question about reconciling financial data and invoices, currently, Logic Sheet does not have the capability to autonomously reconcile financial data by logging into your bank or directly pulling data from external financial systems or websites. The reconciliation processes you described would typically require more sophisticated...
Share Logic Sheet - Google Sheets automation