Awesome work Ryan, looks amazing. I never knew you could creates scripts in sheets.
One thing I might slightly tweak -- instead of having your credentials in the code, use SSM parameter store to keep them, and boto3 calls to get them. I have a separate project called lambda-cache that might help, but native boto3 is also sufficient. This allows you to share you code, freely, while only keeping your secret credentials in Parameter Store, and prevents you from accidentally committing the secrets in your repository to a public repo or something :)
Good call Keith! Totally agreed. I actually wanted to use environment variables in my lambda function to do exactly what you’re suggesting, but I also wanted to keep it as simple as possible for anyone wanting to recreate this for themselves.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Awesome work Ryan, looks amazing. I never knew you could creates scripts in sheets.
One thing I might slightly tweak -- instead of having your credentials in the code, use SSM parameter store to keep them, and boto3 calls to get them. I have a separate project called lambda-cache that might help, but native boto3 is also sufficient. This allows you to share you code, freely, while only keeping your secret credentials in Parameter Store, and prevents you from accidentally committing the secrets in your repository to a public repo or something :)
Good call Keith! Totally agreed. I actually wanted to use environment variables in my lambda function to do exactly what you’re suggesting, but I also wanted to keep it as simple as possible for anyone wanting to recreate this for themselves.