A custom PHP script running as a CRON job on your webhosting server could be
periodically executing your custom scenario as well as give you the option to
trigger the execution manually. The PHP script would
1. Access your Google Spreadsheet using the PHP client library of the Google Sheet API. oAuth authentication will be required.
2. Access a configured Google Sheet of your Spreadsheet and read configured cells
3. Prepare the data for the upload to your Mandrill account
4. Access your Mandrill account using the official Mandrill PHP client and send one or more transactional messages with or without your prepared templates
Please contact me
- with the PHP version you want to support
- a sample of your Spreadsheet with all relevant information
It is possible to deploy the script to your server and configure all relevant
details. The project is possible to complete within 3 days upon acceptance.
shopify, google sheets and amazon aws s3 integration
====================================================
A PHP script for dropshipping of online shopify orders, inserting new rows to
google sheets, notifying the merchant and the supplier with e-mails; accessing
amazon aws s3 buckets to fetch necessary fulfillment data, deploying the
solution on a created, configured amazon ec2 instance.
PHP, GoogleSheets Api, Amazon Aws S3 Api, Amazon EC2, Shopify Api