Configuration of Google Sheets data transfer (through Apps Scrips)
1 .Lids that fall from 17:00 to 01:00 (by Kiev) were automatically transmitted into the created duplicate of this table, and Lids that fall from 01:00 to 17:00 (by Kiev) were ignored and sent in random time from 17:00 to 01:00 with the changed date of receipt of the leads (as the leads that we received from 01:00 to 17:00, appeared in the table where to send, time at the time of entry in the table (B).The tasks
1 .There are no working hours, no working hours from 17:00 to 01:00 in Kiev from Monday to Friday, no working hours from 1:00 to 17:00 in Kiev - on Saturday and Sunday the whole day is no working hours.1.1 Leads from Table No. 1 at work time must be automatically sent to Table No. 2.1.2 The lists listed in Table No. 1 shall be sent in working hours with a changed date and time to the actual at the time of entry in Table No. 2.Persons received outside the working hours and will then be sent to the table No. 2 in employe, must be sent with a frequency, according to the formula "450/col-in received applications = average time of delivery (minutes)"
2ndSet the script so that it sends only unique requests to table No. 2 (unicization by column "H" - there is the phone number)
ThreeFrom Table No. 1 to Table No. 2, only data from columns from A to I should be sent.
P.s The script is already written by another specialist but it works not correctly, i.e. it does not send leads that have fallen in non-work time with the specified frequency and does not change real time to real time.
-
2 days22 USD
460 10 0 2 days22 USD
Good Morning Edward
I have been working with Google apps script for a long time, making them bots that use Google tables as databases.
Let’s make the script you need and make it work as you expect.
-
10 days22 USD
957 19 0 10 days22 USD
Good day . The task is clear. I have experience with Apps Script. I will perform your task using the existing script, or I will write over from scratch.
-
А как лиды изначально попадают в таблицу?
-
все что описали и даже больше можно сделать и настроить используя airtable
Очень продвинутая система учета базы даных.как для личного так и для бизнес пользования
/можно создать любую CRM
https://airtable.com/invite/r/C8ujoxOv
Смотрите по ссылке
-
Current freelance projects in the category Data Parsing
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 3 days 12 hours back ∙ 12 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 3 days 16 hours back ∙ 17 proposals |
Need to scrape data from LinkedIn
We need to scrape data from LinkedIn based on our list. For each entry, we need to find and collect available data if it exists on the LinkedIn profile, including the profile picture on the LinkedIn social network, email address, links to social media, company website, and… Data Parsing ∙ 3 days 22 hours back ∙ 27 proposals |
Parsing and classification of data
We are looking for a developer to implement a system for collecting and structuring data from open sources. We have a database of small business owners in the USA, which contains the person's name, company name, address, and state. It is necessary to build a process for… Web Programming, Data Parsing ∙ 3 days 23 hours back ∙ 41 proposals |
Svitlahata
17 USD
It is necessary to import 1819 products from the XML/YML feed of Prom.ua to OpenCart 3. A ready XML file is available, which contains product names, descriptions, prices, photos, specifications, manufacturers, and categories. Requirements: import all products to OpenCart… Content Management Systems, Data Parsing ∙ 5 days 2 hours back ∙ 34 proposals |
Kyiv