logo
How to Enable Auto Sync in Bulk Product Sync for Real-Time Store Updates in Your Google Sheet

How to Enable Auto Sync in Bulk Product Sync for Real-Time Store Updates in Your Google Sheet

  • Author: Iqra
  • Published On: 10/16/2024

Auto Sync is a powerful feature in the Bulk Product Sync plugin that allows you to send changes from Google Sheets to your store without manual operation. With Auto Sync enabled, every change you make inside your Google Sheet is automatically sent to your store, ensuring that your store always reflects the latest information without the need for manual operation.

To activate Auto Sync, you will need to follow these simple steps:

With Google Sheet Template in New Version

If you have cloned your sheet from our Master Sheet than use following steps:

  1. Click on the “Extension” menu again and select “App Scripts”.
  2. Now click on Triggers from the left menu of the scripts editor.
  3. Create a trigger by clicking “Add Trigger” from the right bottom of the page.
  4. It will open the trigger settings page where you need to set the following:
    • Choose which function to run: AutoSync
    • Choose which deployment should run: Head
    • Select event source: Time Driven
    • Select type of time-based trigger: Select as per your need
    • Select hour interval: Select as per your need
    • Failure notification settings: Set if you need otherwise
  5. Finally, click “Save”.

Without Google Sheet Template (Old Version)

  1. Click on the “Extension” menu again and select “App Scripts”.
  2. This will open the Google Apps Script editor. Inside the Code.gs file, paste the code snippet provided in the plugin documentation. You can find the code snippet by copying this link: 
  3. Save the changes.
  4. Now click on Triggers from the left menu of the scripts editor.
  5. Create a trigger by clicking “Add Trigger” from the right bottom of the page.
  6. It will open the trigger settings page where you need to set the following:
    • Choose which function to run: AutoSync
    • Choose which deployment should run: Head
    • Select event source: Time Driven
    • Select type of time-based trigger: Select as per your need
    • Select hour interval: Select as per your need
    • Failure notification settings: Set if you need otherwise
  7. Finally, click “Save”.
Auto Sync also explained in detail in above video clip.

What is Auto Fetch?

Auto Fetch is reverse of Auto Sync, means getting the changes from website/store to your sheet automatically. Leare more