Connecting your existing Google Sheets document to AppsByB: Inventory&Price Sync allows for seamless updates to your Shopify store's inventory and pricing. This integration streamlines data management, ensuring accuracy and efficiency.
If you already maintain a Google Sheets document with your inventory and pricing, you can easily connect it to the app. If you don't have a document yet, head over to sheets.google.com and create a new document.
Create a public CSV file with Google Sheets
Follow the steps below to publish your Google Sheets document to the web as CSV file.
Open your Google Sheets document or create a new document.
Open the 'File' menu and click 'Share', followed by 'Publish to web' - see the image above.
Under 'Link', click on 'Web page' and change the value to 'Comma-separated values (.csv)' - see the image below.
Click the green button 'Publish'.
Google Sheets will present you with a URL, copy this URL and use the URL when you are adding a source in the app.
