1. Project Goal
Create a script on Google App Script that will allow:
1.1. To automatically parse information from specified Telegram groups based on given parameters.
1.2. To organize the obtained data in Google Sheets in the form of a list according to specified criteria.
1.3. To add functionality for displaying maps with distance calculations between cities if parameters are found in another city. Not mandatory.
2. Tasks
Main Functionality
2.1. Set up integration of Google Sheets with Telegram via Google App Script. Monitor certain Telegram groups. Automatically parse messages that meet specified criteria (for example, type of cargo, city, weight). Save found messages in a table categorized by parameters (for example, "Kyiv", "Dnipro", "China", "Turkey").
2.2. Additional Functionality Implement a function to check distances between cities using Google Maps API: Retrieve distances between cities if the found option does not correspond to the city but is in neighboring ones. Add the corresponding distance calculation to the table. Not mandatory.
2.3. Interface Google Sheets Table: Structured list of obtained data. Filters by cities, weight, container type. Field displaying distances between cities.
Hello! It is necessary to compile a list of Telegram chats suitable for advertising, the theme is gray, Russian. Let's start with 100 chats. The breakdown should be in the following format: chat link, number of participants. It is preferable that the chats are active with a real audience. Please provide the deadlines and cost for completion. Thank you.
Hello I previously posted a project (description below) and received the following result https://docs.google.com/spreadsheets/d/1-abSBtjRZeD_ZGriquW0YUZdbmC4eXcr/edit?usp=sharing&ouid=113724943543706943348&rtpof=true&sd=true as it turned out, unfortunately, later - it is very incomplete... for example, in the table, there is a filter for the city of Neperville - where only 4 dealers are listed. But I manually found 25 such dealers on the maps, and these are not duplicates but unique. Some cities are completely missing. So I am interested in the city of Chicago and the surrounding towns (suburbs), I will provide a list if needed. ---- List of categories from Google Maps from which all companies need to be extracted Car Dealer Used Car Dealer New Car Dealer I also provide a list of categories used by branded dealerships: Toyota Dealer Ford Dealer BMW Dealer Honda Dealer I will provide a list of car brands separately. Generally, within the city, there are several dealerships for each car brand The result in the form of a table. Deduplication through Place ID Price for the work. This is a one-time job. I do not require any script that I will work with further. You can do parsing through your developments or third-party ready services.
Development of automation for Google Sheets + weekly reporting in TelegramProject type: Automation of spreadsheets, data parsing, Google Apps Script / alternatives.Project descriptionThere is an EXCEL spreadsheet (about 45 tabs, some light formulas, historical data). The spreadsheet significantly lags during online work, so it has to be worked on offline. The tasks are: Automate the weekly addition of data from a specific website. Resolve the performance issue. Set up automatic data aggregation and weekly report sending to Telegram.Stage 1. Solving the performance issue + automating data loadingTasks: Analyze the current Google spreadsheet (template will be provided) and propose an optimal solution to the lag issue (large number of tabs and rows). Possible solutions (choose and justify the best one): Optimization within Google Sheets (splitting spreadsheets, using caching, IMPORTRANGE with a smart approach, Google Apps Script). Alternative: migration to Airtable / Notion / Make.com + Power Automate / Python + Google Sheets API. Hybrid solution (main work offline + synchronization). Implement automatic weekly parsing/importing of data from the specified website into the required tabs of the spreadsheet. Set up a schedule (preferably automatic, without manual triggering).Expected result of the stage: A working spreadsheet (or system of spreadsheets) that does not lag during operation. Automatic addition of new data every week.Stage 2. Data aggregation and report sending to TelegramTasks: Set up data collection from specific cells/tabs. Create a pivot table with historical data and percentage ratios (dynamics, % change, etc.). Organize automatic weekly report generation. Set up sending the finished report (spreadsheet + key indicators) to a Telegram bot or a specific chat/channel/group.Expected result of the stage: Automatic weekly report sending to Telegram. Clear, understandable report format.Candidate requirements Excellent knowledge of Google Sheets + Google Apps Script. Experience with website parsing. Experience in optimizing large spreadsheets. Knowledge of Telegram Bot API — mandatory.Implementation details, exact data requirements, deadlines, and costs will be discussed in private messages.
It is necessary to set up the parser remotely (via Anydesk or TeamViewer), something is broken and not working correctly. Mainly replacing the starting links and configuring the parser. Website https://dveri-pol.com/
# Project Overview Premium Haztrak is a modern environmental compliance platform designed to help organizations manage hazardous-waste tracking, electronic manifest workflows, and regulatory compliance records in a more secure, transparent, and legally defensible way, specifially designed for Office of Chief Counsel, PA Department of Environmental Protection, USA. The platform is built around hazardous-waste cradle-to-grave tracking, allowing generators, transporters, facilities, compliance teams, and legal professionals to manage key records, shipment events, supporting documents, signatures, corrections, and audit history in one structured system. The next phase of the project will introduce blockchain-based verification to strengthen record integrity, chain of custody, and regulatory audit readiness without exposing sensitive compliance data on-chain. # Current Version Status The current version provides the foundation for electronic hazardous-waste tracking and demonstrates how a digital system can support EPA e-Manifest and RCRAInfo-related workflows. At this stage, the platform focuses on core hazardous-waste record management, including manifest-related workflows, shipment tracking concepts, compliance documentation, and integration patterns for working with official environmental systems. The current system should be treated as the base layer for a more advanced compliance product. The goal now is to expand it into a premium version with stronger legal, audit, and verification capabilities. # New Integration Goals The main enhancement will be a blockchain-powered compliance verification layer. This blockchain layer will not store private hazardous-waste records directly on-chain. Instead, the system will generate cryptographic proofs for important documents and events, then anchor those proofs to blockchain so records can be independently verified later. # Key integration points include: Blockchain-based proof of manifest records Tamper-evident chain-of-custody tracking Hashing of documents, signatures, corrections, and shipment events Verifiable audit logs for regulatory and legal review Evidence packet generation for disputes, audits, or investigations Secure off-chain storage for sensitive data On-chain proof references for record integrity verification Compliance dashboard for high-risk, incomplete, or disputed records Core Product Features Premium Haztrak should include: Manifest and shipment management Organization and user role management Document upload and record storage Signature and approval tracking Correction and dispute history Chain-of-custody timeline Blockchain proof generation Verification page for documents and records Audit-ready PDF export Legal evidence packet generation Compliance activity dashboard Blockchain Integration Concept The blockchain component will work as a proof layer. When a critical event happens, such as a manifest being created, signed, corrected, received, or finalized, the system will generate a hash of that event or document. These hashes can be grouped and anchored to blockchain through a smart contract or verification registry. This allows a user, auditor, attorney, or regulator to later confirm whether a record matches the original verified version. The private data stays protected in the application database or secure storage. The blockchain only stores verification proofs. #Product Value Premium Haztrak improves environmental compliance by making records: More traceable More trustworthy Easier to audit Easier to verify Better prepared for legal review More resistant to tampering or undocumented changes The product is especially useful for organizations that need strong documentation, reliable compliance history, and defensible records in case of audits, enforcement questions, disputes, or litigation. #Long-Term Vision The long-term vision of Premium Haztrak is to become a trusted digital compliance layer for environmental records. Starting with hazardous-waste tracking and electronic manifest workflows, the platform can later expand into broader environmental compliance areas such as permits, inspections, remediation records, enforcement documentation, ESG reporting, and carbon-credit verification. Premium Haztrak’s goal is simple: To make environmental compliance records secure, traceable, verifiable, and legally defensible.