Hi there, to answer your questions,
1. This is not directly possible but there are workarounds to this.
2. This is possible.
I have excellent command on Google Sheets. I have completed complex projects before. For instance
- Get live cyptocurrency data and create dashboard using coinmarket API
- Upload and Manage Videos in Vimeo using JSON API in google sheets
- Extract mails and attachments from gmail to google sheet and drive respectively
- Twitter functionality like retweet, auto-tweet, and so on
- Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization
You can see the reviews of the same in my profile