Would it be possible to use Shopify’s API to send each of our Shipping Profiles (including all products by title and/or sku) to a separate Google Sheets file and have them synced one way from Shopify to Google Sheets? I know Shopify’s API now allows for access to (delivery profiles) so exporting ‘Shipping Profiles’ is possible I just don’t know if sending this data to Google Sheets (per our requirement) is possible or not.
2
Answers
Google has API calls for your account, so you should be able to do that. At the very least, it is a very easy thing to export data from Shopify like that, and format it as CSV, which you can then import to Google sheets if you cannot figure out their API for sheets.
google-drive-ruby gem is a wrapper for Google Drive API, this is all you need to interact with Google sheets from Ruby land. Good luck!