Search Analytics allows you to automatically export view data to Google Sheets on a daily basis.
Select the Search Analytics view you want to export, then click "Daily Export Settings" in the top right of the graph to configure your Google Sheets destination and permissions.