Automation of Google Sheets (accounting, status) + Slack (conditional notifications) + Task Manager (notifications)
Good afternoon.
It is necessary to set up a convenient and simple system.
We use Slack as our main communication channels.
It is necessary to set up a Google Sheet with status selections, fields for selecting multiple values, payment calculations depending on conditions, and other basic things.
There should be sheets for each user (or separate tables) from which information flows to the main one, so that users do not see each other's information. Also, some values (for example, financial ones) should not be accessible to anyone except the administrator (that is, me). In general, all sorts of basic settings, including PnL in the form of numbers (there are not many values yet, but it needs to be neatly arranged and made convenient, so that there is no excess and at the same time it is easy to use).
Users will select a status and, under certain conditions, a notification should be sent to a specific Slack channel. The same goes for the action plan field; upon filling it out - a notification. A reminder if something is not filled out within a certain timeframe.
It is also necessary to integrate a Task Manager (Trello, Asana, Notion (there is even a working template for it) and other options are acceptable). The main goal is simplicity and ease of use, as well as notifications for remaining incomplete tasks. There is also Workflow in Slack; perhaps, with the help of their tool + Make integrations, simple tasks can be implemented, as well as a basic set of tasks when starting work on the project (as a template).
Please write your proposals (how you see this approximately, or what you recommend) and an estimated cost, as well as your questions.
Thank you
Client's review of cooperation with Roman Levchenko
Automation of Google Sheets (accounting, status) + Slack (conditional notifications) + Task Manager (notifications)Roman is an excellent specialist, he works hard, focuses on quality, pays attention to details, and offers the best solutions. He is open to dialogue. Thank you!
Freelancer's review of cooperation with Nikolay Melnik
Automation of Google Sheets (accounting, status) + Slack (conditional notifications) + Task Manager (notifications)A professional client who can clearly and distinctly explain the task and is always available for a call if something is unclear.
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 5 days 12 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 6 days 4 hours back ∙ 12 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 8 days 3 hours back ∙ 22 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 8 days 4 hours back ∙ 20 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 10 days 13 hours back ∙ 14 proposals |