Export Google Photos data into Google Sheets

Import data from Google Photos into Google Sheets with Awesome Table. Schedule automatic refreshes to periodically update your data.

Install the Google Sheets add-on

Google Photos data you can export into Google Sheets with Awesome Table

Albums
Photos & Videos
Shared Albums

What you can do with Awesome Table

Friendly authentication helperSign in with OAuth2, basic authentication and API keys.

Multi accountsSave and use multiple accounts on the same data source.

Intuitive data fetcherWe make it very easy for you to choose the data you want to import.

Precise schedulerYour queries will run at the exact time you want them to run thanks to our top-notch scheduler.

Interactive query historyEasily track and reuse queries you've run before.

Saved queriesSave queries for later, easily reuse in a different spreadsheet.

Automatic pagination handlingEasily extract as many pages of data you need (as long as it fits in a Google Sheet).

Advanced JSON to Sheet supportMultiple JSON to Sheet conversion options, and filtering with JMESPath.

Email notifications for scheduled queriesGet notified by email when your queries have run.

A growing number of user-friendly connectors

Awesome Table has a huge number of full connectors that is constantly increasing.
Also, you can connect your spreadsheet manually to any API.

Any REST API

Unsplash

Vercel

Youtube

Zendesk

COMING SOON

TikTok

TikTok Ads

Twitter

Airtable

Microsoft Excel

Google Sheets

Shopify

GitHub

Google Analytics

Google BigQuery

Google Datastore

Google My Business

Trello

Quickbooks

Slack

Couldn't find the connector you were looking for?

We're constantly building new data source connectors based on our customers' needs.
If we don't yet offer a connector you'd like to use, please fill the request form.Suggest a new connector