I asked gemini how to use extract data, he helped me to write a question for my brother in law, I wan to copy it here, so I will rememeber and use it later.
You now have a much clearer picture of what you want to achieve. Here's how to structure your conversation with your brother-in-law:
"Hey [Brother-in-Law's Name], I was hoping you could give me some advice on a work project. I'm trying to automate how I get product information into my Google Sheets. Right now, I manually update things, and the data is often outdated.
My Goal: I want to be able to enter a product SKU in my Google Sheet, and have it automatically pull in the latest product details (like name, description, price, etc.) from our company's systems. This would make my daily picklists, request lists, and label printing much more efficient and accurate.
What I've learned so far:
- I knowShopify has an APIand QuickBookshas a developer kit, so I think data can be pulled from those.
- The trickier one is our main PM (Product Management) system. I'm not sure if it has an API, or if I'd even be allowed to access it. My support team manually updates things, so I suspect direct access might be difficult.
My Questions for you:
- How would someone typically go about extracting data like this fromShopify and QuickBooks? (e.g., what kind of programming language is best, what tools are used?)
- Do you have any initial thoughts on how I might figure out if our internal PM system has anAPI, and if so, how I could get access/permissions?
- What's a good starting point for learning aboutAPIs and how to use them? (e.g., a specific online course, resource, or even just the fundamental concepts I should grasp first).
- Do you think this is a realistic project for someone with limited coding experience to learn, or are there major hurdles I'm not seeing?"
This structured approach shows him you've thought about it, know your objective, and are looking for guidance, not just for him to do it for you. He'll appreciate that!
How does this sound as a plan for moving forward? Are there any parts of this you'd like to clarify or adjust?