Cloud Function Python code to store emails in a Google Sheet.

README.md

Subscribe with Email

This is simple implementation for a mini project wherein there is an option for the users to subscribe to a mailing list. This directly adds the user's email to Google Sheets.

---

requirements.txt

# Function dependencies, for example:
# package>=version
gspread>=3.1.0
oauth2client>=4.1.3

subscribe_email.py

import gspread
from oauth2client.service_account import ServiceAccountCredentials

def subscribe(request):
    data = {
      # paste your credentials.json file here
        }
    _name = "Your Google Sheets' Name"
    
    request_json = request.get_json()
    request_args = request.args

    if request_json and ("email" in request_json):
        email = request_json["email"]
    else:
        email = request_args["email"]

    scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']

    creds = ServiceAccountCredentials.from_json_keyfile_dict(data,scope)

    client = gspread.authorize(creds)

    sheet = client.open(_name).sheet1

    rows = sheet.get_all_records()
    for row in rows:
        row_email = row['email']
        if row_email == email:
            return '409'

    sheet.append_row([email])

    return '200'

Hey @alexanu
I meant to put the content of the file there, not the name