This tutorial explains step-by-step how to automate tasks with Google Sheets and send data to and from other apps using Make.
Written version of this tutorial:
How to connect personal Google accounts (custom OAuth connection):
0:25 Send data from sheets to other apps
05:20 Save data from Gmail to Google Sheets