save-email-attachment-to-s3-bucket.py

import boto3
import email
import json
from pprint import pprint
from base64 import b64decode

s3 = boto3.client('s3')
BUCKET_NAME = ''

def lambda_handler(event, context):
    message = json.loads(event['Records'][0]['Sns']['Message'])
    decoded_message = b64decode(message['content']).decode('utf-8')
    email_obj = email.message_from_string(decoded_message)
    
    for part in email_obj.walk():
        content_type = part.get_content_type()
        if 'sheet' in content_type:
            try:
                s3.put_object(Body=b64decode(part.get_payload()), Bucket=BUCKET_NAME, Key="latest-attachment.xslx")
            except:
                continue
    return None