I Will Do Web Scraping Any Web Page by Python and Beautiful Soup

Is it possible to do this automation using python, or another method to automate? basically im trying to do email inside google docs, as you can see in this video: https://drive.google.com/file/d/1LDTeBc4JwLOojclt8Ah0clUFvuA0f86Z/view?usp=sharing so i will have either google sheet - or excel file - which will have 3 columns: A) email addresses B) subject lines C) Email messages and the automation script will email that google doc file , according to the spreadsheet.

So is it possible to do this task? - I have a CSV or Google sheet which has column of websites (business company websites), another column for their company Facebook pages, and so on. - step 1: the automation will go to each website one by one and it will open the homepage and inside homepage search for a Form. - step 2: if it does not find a contact form on the homepage, it can also go to the websites "contact us" page, and search for a Form there. - step 3: once it lands on the form, it will auto-fill the Form and "submit". So we will preload it with what is the name to put there, what email, what subject, what message, etc... - after submitting the form, it goes to the next website and does the same .... ** For the Facebook pages, it will click the "message us" button and submit the message (but this one we have to limit it so Facebook doesn't block our profile, so like maximum 75 messages per day). FOR GROUPON SCRAPER: scraping entire USA country, but only specific categories (the home services category, like plumbing, etc...). I guess we need to provide the specific URLs for that? - it will go down the list of the companies there in that category, and open up each specific page/ad, then it scrapes their company name, location (city and state), and most importantly the website (or Facebook page). - once we collect those websites or Facebook pages, we do the first above task of leaving messages automatically to them.

Ok I will wait for you. Do you also know how to scrape websites like Groupon.com?

Do you understand how to use this: https://github.com/JJTech0130/textfree To be able to send and receive bulk SMS messages? And have full conversations?