Python Google Sheets as backend

app.py

from __future__ import print_function

import json
import time
import os

from flask import Flask
from googleapiclient.discovery import build

SCOPES = ['https://www.googleapis.com/auth/spreadsheets.readonly']

SAMPLE_SPREADSHEET_ID = os.environ['SPREADSHEET_ID']
SAMPLE_RANGE_NAME = 'A:D'

service = build('sheets', 'v4', developerKey=os.environ['KEY'])
sheet = service.spreadsheets()


def main():
    start = time.time()
    result = sheet.values().get(spreadsheetId=SAMPLE_SPREADSHEET_ID, range=SAMPLE_RANGE_NAME).execute()
    values = result.get('values', [])

    res = []
    if not values:
        print('No data found.')
    else:
        print(values)
        keys = values[0]
        for row in values[1:]:
            now = {}
            for r, k in zip(row, keys):
                now[k] = r
            res.append(now)
    print(res)
    print(time.time() - start)
    return res


app = Flask(__name__)


@app.route('/', methods=['GET'])
def homepage():
    return json.dumps(main())


if __name__ == '__main__':
    app.run(debug=True)