Web scrapping + chatgpt + WP Events Manager plugin

Please do not make a quotation before reading the complete work. 1- We need to perform web scrapping of a website that we will indicate at the beginning of the job. It is to extract the data that I attach in the excel example of a website similar to tradefairdates dot com (please search in google). In total there are 16 countries, which together add up to a total of 40 cities. You can see a screenshot of how this info would be organized in the listing (A). At the same time we need that inside the scraping also download the information about the fairgrounds, with its photo and description. Here you can see how the fairgrounds would look like (C) 2- The excel (xslx) resulting from the scraping must be passed through chatgpt for excel to create a new description of each fair and a new description of each enclosure so that there is no duplicate content. The dates, locations, logos, etc. will be left the same. We will provide the chatgpt keys for excel, attached is a screenshot of the plugin. For the description we will use the cheapest model, which is already enough to create the descriptions. You can also use chatgpt for google sheets, we have not used it, but it is possible to do everything directly in sheets. see (F) 3- The resulting information must be stored in a google sheets file, we will provide the account passwords. This file should be automatically synchronized with the events manager plugin data. For this, you must first configure for us a google cloud account to be able to connect with google sheets see(E) 4- You must access to our wp admin, and configure our paid plugin (WP Events Manager) here I leave the plugin information: [login to view URL] so that the information is updated dynamically from the google sheets file. - You must perform the import, matching the form data with the plugin see screenshot (D) this is just an example with generic cell names. - It is essential that all fields in the google sheets file are correctly reflected by the plugin in the corresponding page of our site (event listing, individual page of each event, and location of each event) We will not use any more functionalities of the plugin (no registration, no ticket purchase, only the specified). Redirection to our landings: We have on our website about 310 landing pages (european trade shows) that should be linked to the corresponding title on the listings (when there´s a match we sill skip the default individual page (B) and replace it for our corresponding landing see on example([login to view URL])). In the case of not matching (not existing among our landings the event in question), the standart individual page will be used (B) 5- Every 4 months we will ask for a new scrapping to update the data in the google sheets template. this is not only because our events will appear but also because we will need to update those that did not have all the information (many events, especially those of 2026/27 do not include precise dates, and when the organizers finally give them, we need to update the information). In this case it will only be necessary to pass through chatgpt the information of the new fairs, which will not be many. this work will be budgeted separately at the time. 6- Skills that we consider necessary to perform this job: (please do not accept if you do not have them) - 1 Have extensive knowledge of web Scrapping - 2 have previous experience working with WP Events manager or similar calendar plugin, with direct synchronization from google sheets - 3 Extensive proficiency with Google Cloud Platform, to set up permissions - 4 Proficiency in PHP, javascript to configure and customize the plugin - Knowledge of chatgpt plugin for excel /sheets or similar - 5 Worpress, excel, etc -VERY IMPORTANT: - Because this work involves the revision of a lot of information, we will reward with an additional 20% to the final agreed price if the work does not exceed 5 revisions. that is, 2 revisions for the scrapping and 3 for the rest of the work. - We assume you have the knowledge needed for all task in this job. In case you need help for a particular doubt, you will need to adress to Events manager pro support and documentation.