So You want to sync data between sql and google sheet. Below is my solution for your requirement.
We will develop a simple desktop or web app which will contains a text box (input for item number) and button. when the user press the button it will take all the data for that item number and update the google sheet.
About me:
Hey, My name is Tahir; I'm a Microsoft Certified Solutions Developer(MCSD) located in Islamabad. I've a sound experience in asp.net(core), mvc, entity framework, sql server, web api and bootstrap.
I'm highly interested in your work, and i believe it fits my area of expertise.
I'm looking forward to hear from you.