Seeking Programmer for Twitter API and Google Sheets Integration

Hello, I am looking for a programmer with expertise in the Twitter API and JavaScript for Google Sheets. I require assistance in setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to fetch tweets within a specific date range through an added menu in Google Sheets. 3. Data Integrity: - Ensure that existing data in Column B is not overwritten, preserving manually entered or previously fetched data. 4. Customization: - Clearly mark sections in the script for easy customization, such as token keys and Twitter account details, to allow for simple modifications as needed. 5. Notifications: - After new content is fetched, enable the script to send notification messages (5 to 10) via email to inform my translation team about the new updates. - If feasible, also implement notifications via WhatsApp, using the phone numbers of the team members. Additional Requirements: - I would appreciate if candidates could provide a demonstration video, sample work, or a detailed explanation of how they would approach this project. This will help me assess your understanding and ensure you are the right fit for this task. Application Instructions: Please submit your proposal with the aforementioned details and any relevant experiences. Understanding my requirements clearly will be a key factor in my selection process. Additional Considerations: I am also open to any constructive suggestions or improvements proposed by the programmer. I am not looking for a partial solution; if you see any aspect that could be enhanced or added to my request, I welcome your insights and innovations. I value proactive engagement and creative solutions that could enhance the efficiency and functionality of the project. I look forward to your innovative solutions and working together to streamline our workflow. Best Regards,