I'd like to write a script that interacts with my google Drive account and my wp database. If this seems feasible, would that script need to be inside of wp / on my local machine?
My sense was that some of what I'd like to do should be possible with the wpdb method. Some basic questions to that end:
1) If I write a script to add elements to the db, where would I run it?
2) Will the script need to be in php?
About the script:
Ideally it would include one cron job which uploads updates to my wp database; and another which sends out a newsletter with the gDrive spreadsheet info.
I think the latter should be possible using the Newsletter Manager plug-in. How about the former? If this seems possible, any recommendations?