The task 1c

We are looking for a specialist in Google Sheets to support the existing work tracking table and payroll calculation. The table has already been created and contains many formulas and interconnections between sheets. Currently, there are errors that need to be found and corrected. Requirements: analyze the structure of the table; find and fix errors in the formulas; restore the correct functioning of the table if necessary; explain the working principle so that we can independently make simple changes in the future; provide ongoing support for the table if possible. Experience with Google Apps Script will be an advantage if the table uses automation. Before starting work, I will provide access to the table and explain what the problem is.

Adding document photos via a Telegram bot. The connection to BAS should be implemented as an extension - without changing the configuration. Settings: 1. Log for setting which objects it will work with. An object can be a document or a directory. 2. User log of the bot. The log confirms bot users, links to BAS users (a bot user may not be a BAS user), default department 3. Access settings for storage on FTP 4. Settings for departments and directories on FTP for departments Registration 1. by phone number 2. Confirmation of registration in BAS (check the active box) Operating mode. Mode 1. 1. From the document, the "add photo" button is pressed. (the button for the user is pressed only once, and until the operation is completed in the bot, it is inactive for this or other documents) 2. The bot sends a message to the user "add a photo or document". 3. The user attaches a photo (one or several) and presses the "send" button in the bot (or cancel) 4. A message in Telegram about the success of the sending. 5. The photo is attached to the document in BAS. Mode 2. 1. Photos are added to the bot 1 or several 2. A "send" button appears (or cancel) 3. A message in Telegram about the success of the sending 4. File upload to the department's directory. The file name is formed as: 2026_06_24_Document_Telegramuser

Create a form with a button that, when clicked, prompts the user to specify where the USB drive is inserted. After the response, return the hardware identifier of the USB drive. All of this should work on a web client.

Looking for a specialist in business process automation. Need to conduct an audit of routine tasks (orders, reporting, spreadsheets, communication, control) and implement effective solutions. Requirements: experience with AI, Google Sheets/Apps Script, Telegram bots, CRM, integrations (Make, Zapier, n8n). Expectations: process audit; identification of bottlenecks; proposals and implementation of automation; minimization of manual work. The goal is to automate repetitive processes and free up the team's time for development.

We are an e-commerce company (cross-border sales on Amazon/Walmart). We are moving from Monday to ClickUp. The basic structure (Spaces, Task Lists) has already been set up, now we need an experienced specialist to "fine-tune" the system to our business processes and set up automations. What needs to be done: 1. Refinement: The team finds it inconvenient to work with standard cards, they need to be customized to our request. 2. Automation: Deduplication during import: we need to set up the import of reports (CSV) via Make/n8n or scripts. When uploading a new file, the system should automatically check for duplicates (for example, by order number) and update existing records instead of creating new ones. Interdepartmental triggers: set up chains: when IT changes the status of a task -> the next task automatically appears for logistics/sales. Telegram bot: Automatic task creation in ClickUp from messages in Telegram (with text attachment and link to the source). 3. Security and backups: Setting up automatic backup of the database (for example, in Google Sheets). Solutions for safe data handling to minimize the risk of "mass data corruption" and ensure quick rollback of changes (Audit Log/Backups). Candidate requirements: Experience with ClickUp API (specifically API, not just basic list creation). Practical skills in Make (Integromat) or n8n. Understanding of e-commerce logic (Amazon/Walmart) will be a big plus. What we expect in the response: Estimated timelines for auditing the existing system and initial setups and budget. We are looking for a reliable partner who understands our specifics and will help build a working system. We look forward to your proposals!