How can I get some particular values into Open office calc at my local PC from google spread sheet?

Hello, I would like to get some values at openoffice calc importing from google spreadsheet. I put two pictures files as reference: The one is google spread sheet picture file - Googless.jpg, Another one is Oracle Openoffice calc picture file - Openof.jpg. First of all, I add some values in each columns(PID, category, product, test c, price from the left to the right). And I have made open office calc file at the desktop / my local PC. Everytime I add PID number at my local open office cal file, I would like to automatically grab the values at category, product and price at google spreadsheet and put the values at the row where PID number is located at Open Office on my local PC. How can I get it? Sincerely, portal
googless.jpg
openof.jpg