Here's a short walkthrough how to export a Google Document with Paperpile citations to EndNote and Word.
Paperpile uses unique citation codes for the in-text citations and saves the code as field "Label" in the corresponding RIS file with the reference data. So step (7) is crucial to tell EndNote how to match the citations in the Word file with the references in the RIS file.
(1) Open "Export menu" in the add-on sidebar.
(2) Export the document with "EndNote citation codes"
(3) Export the references as "RIS"
(4) Download the new copy of the document as "Microsoft Word (.docx)"
(5) In EndNote choose 'Import > File'
(6) Import the RIS file, use the options shown
(7) In the EndNote preferences click "Use field instead of record number" and choose label
(8) Open the .docx file in Word and click "Update citations and Bibliography"
(9) EndNote should format the citations and bibliography correctly. Change back the option in (7)
Disclaimer: We don't encourage you to do that. We have added his functionality for the use case when you (for whatever reason) absolutely need to have a final manuscript prepared in Word and EndNote.
This process is a one way street: you can't bring back the document to Google Docs in a format that can be understood by Paperpile.