You can use Awesome Table Connectors to export data from Unsplash to Google Sheets by logging in with the Unsplash connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Unsplash connector.
On the Connect to Unsplash screen, click Sign in with Unsplash.
On the Unsplash login page, choose the login method you want to use.
Click Continue as to accept the Awesome Table authorizations.Awesome Table informs you if your connection is successful.
The Awesome Table add-on shows a link to the Unsplash API documentation and provides options to configure your API request.