To import data from Google Photos into Google Sheets, follow the steps below to log in to Google Photos with the Awesome Table add-on.

Procedure

1. In the Awesome Table add-on, select the Google Photos connector.
   
2. On the Connect to Google Photos screen, click Sign in to Google Photos.
   
3. Select your Google account.
   
4. Click Allow to grant Awesome Table the permissions it requires to import data from Google Photos.

   

   If your authorization is successful, Awesome Table shows the following screen.

   

Result

You are now logged in with the Google Photos Connector.

The Select data drop-down shows the data you can import from your Google Drive into Google Sheets.