Excel macro to read Deal information


i have an Excel spreadsheet that i use amongst other things to track my quotes. It runs various macros etc.
I am trying to have it read a few fields from Excel - namely a couple custom fields but other fields like name and address of leads to put them in the spreadsheet.

is there a way i can do this - not proficient in writing API, thought there was a way from within Excel. Does someone have any idea on how i can select a lead from Pipedrive from within excel. NOt looking to export and import.

Any assistance will be greatly appreciated

Thanks in advance

Although I do not have an excel macro per se. I see that you can find some useful information here Using Google App Scripts for automation / integration
Feel free to create a new topic if you still face challenges.