Help Me plz #723

Arshkamran1 · 2023-01-13T10:15:24Z

Arshkamran1
Jan 13, 2023

My code uses google sheets, and then sends an email to the last row added. It runs locally but when I run it in the micro I get this Running micro...

Response:
{
"error": "No function found for action 'an empty action'"
} I have installed all the dependencies what should I do

jnsougata · 2023-01-21T08:39:06Z

jnsougata
Jan 21, 2023

Can you share some code we can look at?

3 replies

Arshkamran1 Jan 21, 2023
Author

here is the code for main.py
from googleapiclient.discovery import build
import pandas as pd
import time
from send_email import send_email
from google.oauth2.credentials import Credentials
from google.oauth2.service_account import Credentials
import json
from deta import app

@app.lib.cron()
def cron_job(event):

spreadsheet_id = '1422gMeYwrhGoMXasvQ8_FDoxiTAblM5yivfJyYO3w7M'

range_name = 'Sheet1!A1:Z1000'

creds = Credentials.from_service_account_file(
    'email-374509-4f72425b93d2.json', scopes=["https://www.googleapis.com/auth/spreadsheets"])

service = build('sheets', 'v4', credentials=creds)

result = service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id, range=range_name).execute()

df = pd.DataFrame(result.get('values', []))

initial_rows = df.shape[0]

while True:

    result = service.spreadsheets().values().get(
        spreadsheetId=spreadsheet_id, range=range_name).execute()
    df = pd.DataFrame(result.get('values', []))

    current_rows = df.shape[0]
    if current_rows > initial_rows:

        send_email(df.iloc[-1])

        initial_rows = current_rows

    time.sleep(60)

and here is the code for send_email function

import os
import smtplib
from email.message import EmailMessage
from email.utils import formataddr
from pathlib import Path
from dotenv import load_dotenv

PORT = 587
EMAIL_SERVER = "smtp.gmail.com"

current_dir = Path(file).resolver(
).parent if "file" in locals() else Path.cwd()
envars = current_dir / "email.env"
load_dotenv(envars)

sender_email = os.getenv("EMAIL")
password_email = os.getenv("PASSWORD")
app_password = os.getenv("APP_PASSWORD")

def send_email(row):
subject = "Your order is on its way"
name = row[0]
last_name = row[1]
reciever_email = row[2]
number = row[4]
street_address = row[5]
city = row[6]
province = row[7]
postal_code = row[8]
payment_method = row[9]
date = row[10]
items = row[13]

with open('email_template.html', 'r') as file:
    email_template = file.read()
email_template = email_template.format(name=name, last_name=last_name, city=city,
                                       province=province, postal_code=postal_code, street_address=street_address, number=number, reciever_email=reciever_email)

msg = EmailMessage()
msg['Subject'] = subject
msg["From"] = formataddr(("Khana", f"{sender_email}"))
msg["To"] = row[0]

msg.set_content(
    f"""\
        First Name: {name},
        City: {city}
        Province: {province}
        Postal Code: {postal_code}
        Street Address: {street_address}
        Number: {number}
        Last Name: {last_name}
        """

)

msg.add_alternative(
    f"""\<html>

<title>Order Confirmation</title>

Your order has been placed

Below our the details of your order

Date:{date}

First Name:{name}

Last Name:{last_name}

Email Address:{reciever_email}

Phone Number:{number}

Street Address:{street_address}

City:{city}

Province:{province}

Postal Code:{postal_code}

Payment Method:{payment_method}

Order Details:{items}

This is a test

""", subtype="html" )

Arshkamran1 Jan 21, 2023
Author

srry this is the code for send_email function

import os
import smtplib
from email.message import EmailMessage
from email.utils import formataddr
from pathlib import Path
from dotenv import load_dotenv

PORT = 587
EMAIL_SERVER = "smtp.gmail.com"

current_dir = Path(file).resolver(
).parent if "file" in locals() else Path.cwd()
envars = current_dir / "email.env"
load_dotenv(envars)

sender_email = os.getenv("EMAIL")
password_email = os.getenv("PASSWORD")
app_password = os.getenv("APP_PASSWORD")

def send_email(row):
subject = "Your order is on its way"
name = row[0]
last_name = row[1]
reciever_email = row[2]
number = row[4]
street_address = row[5]
city = row[6]
province = row[7]
postal_code = row[8]
payment_method = row[9]
date = row[10]
items = row[13]

with open('email_template.html', 'r') as file:
    email_template = file.read()
email_template = email_template.format(name=name, last_name=last_name, city=city,
                                       province=province, postal_code=postal_code, street_address=street_address, number=number, reciever_email=reciever_email)

msg = EmailMessage()
msg['Subject'] = subject
msg["From"] = formataddr(("Khana", f"{sender_email}"))
msg["To"] = row[0]

msg.set_content(
    f"""\
        First Name: {name},
        City: {city}
        Province: {province}
        Postal Code: {postal_code}
        Street Address: {street_address}
        Number: {number}
        Last Name: {last_name}
        """

)

msg.add_alternative(
    f"""\<html>

<title>Order Confirmation</title>

Your order has been placed

Below our the details of your order

Date:{date}

First Name:{name}

Last Name:{last_name}

Email Address:{reciever_email}

Phone Number:{number}

Street Address:{street_address}

City:{city}

Province:{province}

Postal Code:{postal_code}

Payment Method:{payment_method}

Order Details:{items}

This is a test

""", subtype="html" )

with smtplib.SMTP(EMAIL_SERVER, PORT) as server:
    server.starttls()
    server.login(sender_email, app_password)
    server.sendmail(sender_email, reciever_email, msg.as_string())

if name == "main":
send_email(row=["bob", "bob",
"[email protected]", "Waterloo", "647", "horizon", "", "Ontario", "L4B"])

jnsougata Feb 1, 2023

Sorry for replying late. Are you getting any specific errors?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Help Me plz #723

{{title}}

Replies: 1 comment 3 replies

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Help Me plz #723

Arshkamran1 Jan 13, 2023

Replies: 1 comment · 3 replies

jnsougata Jan 21, 2023

Arshkamran1 Jan 21, 2023 Author

Your order has been placed

Below our the details of your order

Arshkamran1 Jan 21, 2023 Author

Your order has been placed

Below our the details of your order

jnsougata Feb 1, 2023

Arshkamran1
Jan 13, 2023

Replies: 1 comment 3 replies

jnsougata
Jan 21, 2023

Arshkamran1 Jan 21, 2023
Author

Arshkamran1 Jan 21, 2023
Author