Google Sheets

Google Sheets is a spreadsheet platform used to store, organise, and manage structured data in rows and columns.

Product data is stored and managed within Google Sheets through a Make scenario connected to ShopWired. When products are updated in ShopWired, the scenario checks for an existing row using the SKU and either updates it or creates a new row in the spreadsheet.

• Keep product data updated in your spreadsheet

• Product details such as title, stock, price, and weight are synced when updates are made in ShopWired

• Automatically match products using SKU codes

• Existing rows are identified using SKU codes, ensuring the correct product data is updated

• Add or update spreadsheet records automatically

• New rows are created for new SKUs, while existing rows are updated when matches are found

1. Create a Google Sheets account if you don't already have one
2. Create a new scenario in Make using the Google Sheets blueprint
3. Connect your ShopWired webhook and Google account
4. Select the target spreadsheet and sheet for product data
5. Product updates in ShopWired automatically sync to Google Sheets