- Install PHP server in your system.
- Composer need to be installed which is a package installer for php
- Activate Google Sheets API for your account
- Copy the credentials.json file that is downloaded after completing API activation into source folder.
- In cmd type this
composer require google/apiclient:^2.0
. - Run
sample.php
in cmd.
sample.php
contains code for getting links from google sheet and update prices into sheets.index.php
contains code for getting prices from product link.