How to add Autocomplete to Google Sheets via App Scripts

Question

I am attempting to recreate the following feature within the cell of a Google Sheet which is being used as a Form. I have setup the Places API and Key Restrictions.

This is the feature that I believe I should be able to create (the 1st example):

https://developers.google.com/maps/documentation/javascript/places-autocomplete

"Autocomplete adds a text input field to your web page, and monitors that field for character entries. As the user enters text, autocomplete returns place predictions in the form of a dropdown pick list. When the user selects a place from the list, information about the place is returned to the autocomplete object, and can be retrieved by your application."

In other words, the user starts typing the location name, such as, "Oracle Park" and the Places API Library should return the most relevant Addresses, such as, "Oracle Park, 24 Willie Mays Plaza, San Francisco, CA 94107"

Side Note: It should NOT have an issue with returning that park address in another country such as India because the countries would supposedly be restricted to the United States per this script, which is pasted from this Tutorial: https://www.youtube.com/watch?v=cJjUALvnpCU&t=98s

{ 
componentRestrictions: { country: ["us"] }, 
fields: ["address_components"], 
types: ["address"], 
} 

End Side Note.

Can anyone please point me to a cohesive tutorial to add the Autocomplete feature which returns the Street Address for a typed Location (restricted to the country of the United States) within a Google Sheets Cell via Google Apps Script? This should work exactly like Google Calendars wherein the user starts typing the name of the location and clicks on the correct address to populate that field. Except, instead of Google Calendars, this field is in a Google Sheets cell.

Many thanks.