I developed a fully automated Excel VBA script that manages LinkedIn connection requests and follow-up messaging. This project was designed to streamline the process of sending invitations and follow-up messages, making it easier for my client to network and engage on LinkedIn.
Project Details:
Automated Connection Requests:
- The script reads LinkedIn profile URLs from an Excel file and sends connection requests automatically.
- After a predefined number of days, the script checks if the request has been accepted. If accepted, the script logs the acceptance date and time.
Automated Messaging:
- Once the connection is accepted, the script sends a follow-up message using a predefined message template stored in a text file. The path to the message file is specified in the same row as the profile URL.
- The script logs the date and time the message was sent or marks it as “Failed” if unsuccessful.
Customization Features:
- The user can set a pause interval between processing each profile to avoid rate limits and also define wait times after sending requests or messages. These values can be adjusted based on specific needs.
- The system includes three buttons: Open Browser (to open a Chrome browser using Selenium ChromeDriver for LinkedIn login), Run Script (to execute the automation process), and Close Browser (to close the browser once the script completes).
How I Achieved It:
- I utilized Excel VBA integrated with Selenium ChromeDriver to control browser automation. This allowed for seamless interaction with LinkedIn’s website and its elements.
- Error handling and logging mechanisms were implemented to ensure the system tracks successful and failed actions, giving the client full transparency.
- The system was built to run on Windows OS and was customized to the client’s specific networking workflow, ensuring smooth automation without LinkedIn blocking the actions.
This project helped my client automate their LinkedIn networking process, saving hours of manual work and increasing efficiency.
Screenshots:
If you need custom automation tools for LinkedIn or any other web platform, I can create a solution tailored to your requirements. Don’t hesitate to Contact Me.
