My response to
@Andy Black
Can you create bots to “scrape” websites or Facebook pages and pull back data parsed into rows in a Google Sheet?
With enough time, money & budget yes.
Can you take rows in a Google Sheet as input and generate a web page per row?
I have already done this with a WordPress site. Yet to do it with static though I would use Ghost for this purpose.
Can you take a description of up to 40 characters and split it into two Google Ads headlines of up to 30 characters, where the split isn’t partway through a word in the original 40 character description?
As long as the are no hyphenated words and full stops are used properly. How would you want to determine the position of the split? Just a matter of time & money.
Can you take the listings from a Shopify store and convert it into a Google Sheet to be uploaded to Google Merchant Center as a supplemental feed for Google Shopping campaigns?
By listings do you mean paid order, cancelled order or any status order? Or do you mean products? Yes for the right budget.
Can you setup and automate reports from Google Data Studio so that every Monday 30 clients get a weekly view of their last 10 weeks performance?
I have only browsed the connectors. Looks like there is probably some way of doing it. Would be a while before I could do it.
Also adding in the Change Log and Comments from a Google Sheet setup for each client?
That is probably the easiest part.
Can you automatically pause the ad group for any keyword that has a quality score of 2 or less for charity clients so they can stay compliant with Google’s policies and remain eligible for their $10k/mth grant for ad spend.
This depends on the quality score. There is no easy way to pull it out. If it can be calculated from other data or I can find an API call for it then it's just a budget issue.
Can you bulk upload 30 Soundcloud recordings into iTunes and retain their creation dates?
No.
Can you bulk change the description and tags for over 100 YouTube videos that haven’t got any description or tags?
Not without better internet and a better computer.
Maybe from a Google Sheet so formulae can be used to generate the descriptions and tags?
Perhaps in the future.
Can you set up Thrivecart and ActiveCampaign so that a paid email
newsletter can be created that automatically unsubscribes people when they stop paying?
If ThriveCart will give me API access then yes, just a matter of budget.
Can you create a Zapier zap so that people who buy a Thinkific course get tagged or added to another MailCheat(Chimp) list or are otherwise separated from the people just taking the free trial?
For the right budget yes.
Can you write similar examples of what you *have* done that can show people what you’re capable of, and to get their wheels turning?
I did. Further up in the thread. Also I have done automatically download invoices sent by email to Google Drive and add to catalogue on GoogleSheet to make it easier to find.
Also I came up with a way to detect a number of software bugs at the requirements gathering stage. As I''m sure @andyblack knows finding them in the testing stage is much more expensive. That's easily $1400-$9900 saved depending on if the bug would have been caught at testing or not.
It's hard to even get the software specs to do a test and a quote.
I can also offer web design. Or web design and your web pages from Google Sheets if there is demand for it.
SOP is Standard Operating Procedure, right?
Sure that's just programming. Albeit for wet mushy computers. Average Human Readable or Programmer Readable? Ideally. I would want 3 videos because people never repeat the actions they think they do.
I could manage with one video with good subtitles and the narrator available for clarification via email/instant messenger though.