Create a formula in Google tables

Need to list products on the OpenCart site. There are approximately 100 products. All products are copied from another site, but the description and so on will need to be changed. So finding photos and specifications is easy. I will describe the detailed terms of reference in private if interested. Only live listing, no programs for parsing, etc.

A market analysis of potential clients is required for a creative marketing agency that creates over 5,000 advertising creatives per month for Meta, TikTok, YouTube, AppLovin, and other advertising platforms. Project Goal To identify priority niches and specific companies that regularly need large volumes of advertising video content. The results of the research will be used to build the agency's sales strategy for the next six months. Main Tasks The contractor must: identify 10–15 most promising niches; explain why each niche requires a large number of advertising creatives; identify the main advertising platforms and formats for each niche; find specific companies that actively use performance advertising; justify the selection of each company; determine which services the agency should offer them; create a priority list of companies for contact. Examples of current clients and additional information about the agency will be provided to the selected contractor separately. Niche Analysis ( For each niche, it is necessary to specify (Niches should be divided into three categories: high, medium, and test priority.): main advertising platforms; need for vertical video, UGC, motion design, and AI creatives; frequency of ad updates; need for testing hooks, offers, and variations; Company Search For each priority niche, it is necessary to find companies that: actively run ads on Meta, TikTok, YouTube, or AppLovin; regularly update advertising creatives; operate in multiple countries or with several products; scale user acquisition; may need an external production partner. For each company, it is necessary to specify: website, country, niche, and main products; advertising platforms used; examples or confirmations of advertising activity; why the company needs a large volume of creatives; which service should be offered to them; approximate potential workload; contact priority; relevant decision-makers and links to LinkedIn. Sources The research should be based on current and verified sources: Meta Ads Library, TikTok Creative Center, Google Ads Transparency Center, App Store, Google Play, LinkedIn, company websites, job postings, investment databases, and industry reports. Priority geographies: USA, Canada, UK, Australia, Eastern Europe. Expected Outcome The contractor must provide: A brief analytical report with a ranking of niches. A table with 150–300 potential companies. A separate list of 30–50 companies for the first wave of contacts. Justification for the selection of each priority company. A recommended offer and personalized approach to contact. Recommendations for the order of testing niches over the next six months. The main result of the project is a clear understanding of which niches to develop, which companies to contact first, whom exactly to write to, and which services to offer them. We expect examples of similar research from you (without them, candidates will not be considered) and your wishes regarding the terms.

Hello I need to gather contacts of companies in 5 French-speaking regions of Switzerland (Geneva, Vaud, Neuchâtel, Jura, Valais Details - - manufacturing companies and service providers - focus on local companies or international companies that have business in the country - large and medium enterprises or small businesses that have several offices-stores-garages-etc. (any chains) Details 1. manufacturing - any enterprises in the 5 regions of the country (including food products (chocolate, cheese, dairy, and others) 2. services - - transport companies, - cleaning companies (for cleaning - transport (buses, trams, metro), airports, business centers, stores, universities, and other educational places (schools, kindergartens), customs, police - medical institutions (excluding hospitals), - car dealership chains, - sports clubs, - restaurant chains (individual restaurants are not needed), - distributors of cleaning products for businesses or local municipalities, - car wash chains, - hotel chains in this country (one hotel is not needed), - companies that conduct cleaning-washing of yachts on Lake Geneva, The result of the work will be - a table with contacts of the above-mentioned companies (region name, industry, company name, company website, email, phone number, address, company LinkedIn link, 2-3 contacts from the purchasing department (for large and medium companies) and management for small enterprises (including chains) with name, position, email, phone, and LinkedIn links (if available) Evaluation - a minimum of 300 companies for which there is a budget of 3,000 UAH or 10 UAH for each contact I am ready to answer all questions Thank you

We are looking for a developer or a team to implement an AI sales manager in Bitrix24 based on OpenAI / ChatGPT. Important: we need a contractor who already has experience with similar developments: Bitrix24 + OpenAI / ChatGPT + open lines + CRM. We do not consider performers who will "learn on the project." It is preferable to have ready-made solutions, project examples, and recommendations from other business owners. About the project - We have a service for international purchasing and delivery of goods from foreign stores. Bitrix24 is cloud-based, Professional tariff. Main application channels: — Avito; — WhatsApp; — Telegram; — MAX; — Instagram; — website chat; — email; — VKontakte; — Odnoklassniki. In Bitrix24, funnels are already set up: Incoming leads and sales. Logistics / questions about parcels. Regular customers. Marketing / cold leads. What needs to be done - We need to implement an AI manager that can: — consult clients in open lines; — answer frequently asked questions; — calculate preliminary delivery costs, commissions, and shipping rates; — collect client data: country of purchase, product link, delivery city, weight, dimensions, budget, and a number of other tasks that are outlined in our technical specifications for the developer. All accesses, accounts, subscriptions, server, OpenAI API, Bitrix24 webhooks, code repository, and knowledge base must be registered in our name! After the work is completed, the contractor must transfer: — source code; — repository; — architecture diagram; — instructions for setting up Bitrix24 and OpenAI; — instructions for updating the knowledge base; — instructions for disabling AI; — instructions for managers; — documentation for future developers. It is important for us that the system does not depend entirely on one contractor. Requirements for the contractor - We need a specialist who: — has already worked with Bitrix24 + OpenAI / ChatGPT; — understands open lines in Bitrix24, CRM, webhooks, REST API, tasks, and bots; — can show similar projects; — can provide recommendations from clients / business owners; — has ready-made solutions or code that can be adapted; — understands sales business processes; — proactively suggests how to best implement the project, rather than just waiting for a ready-made technical specification or, worse, responding with "I'll do it as you want"; — can warn about risks; — is ready to support the project after launch on a subscription basis. We do not make calls if you do not meet these requirements and have similar experience. If the developer cannot propose an architecture and does not provide professional recommendations for implementation, such a performer is not suitable for us. A warranty period for error correction is needed. You can request our technical specifications in advance to estimate the development budget. After launch, technical support is also needed: — error correction; — consultations; — log checking; — knowledge base updates; — scenario refinement; — assistance during OpenAI / Bitrix24 failures; — training for the owner and team. In your response, please immediately write: Have you already worked with Bitrix24 + OpenAI / ChatGPT? Do you have ready-made solutions / code? Can we see similar projects? Are there recommendations from clients? What is the approximate budget for implementing the bot? Link to the technical specifications https://docs.google.com/document/d/1V79aslqSQIEZHZmX5WwR6Yl_4xbsU1tP/edit

An activated SIM card from a Serbian operator is required for receiving SMS and registering on WhatsApp. Please provide a price.