Hi,
Google sync PRO version allows fetching products from your site into Google Sheet. It is a straightaway process to fetch products. Just click on the Google Sync menu and click Fetch Products.
However, there are some tips to fetch a larger amount of products like over 5k. So you need to follow these steps.
1. Make sure you have the latest Google Sync Free & Pro version installed.
2. Make sure you have set chunk size (inside **settings** sheet) 500
3. If you Maximum execution timeout error on the Google sheet, then you should make the following settings:
3.1 Products Syncback Settings
> Fetch New Products (Non-synced) Only
. This will only fetch products that are not fetched already. And you can repeat this step more than one time until all your products are fetched.