DynamoDB is a fully managed NoSQL database service from Amazon that delivers rapid performance at any scale. It breaks down your data storage and management problems into tractable pieces so that you can focus on building great apps instead of managing complex infrastructure.
Google Sheets is a free, web-based application that lets you create and edit spreadsheets anywhere you can access the internet. Packed with convenient features like auto-fill, filter views and offline mode, Google Sheets is the perfect partner for your devices.
Want to explore Amazon DynamoDB + Google Sheets quick connects for faster integration? Here’s our list of the best Amazon DynamoDB + Google Sheets quick connects.Explore quick connects
Looking for the Google Sheets Alternatives? Here is the list of top Google Sheets Alternatives
It's easy to connect Amazon DynamoDB + Google Sheets without coding knowledge. Start creating your own business flow.
Trigger when new item created in table.
Trigger when new table created.
Triggers once a new spreadsheet is created.
Triggered when a new row is added to the bottom of a spreadsheet.
Trigger when a new row is added or modified in a spreadsheet.
Creates new item in table.
Create a new item or updates an existing item.
Insert a new row in the specified spreadsheet.
Create a new spreadsheet row or Update an existing row.
Share Google Sheet.
Update a row in a specified spreadsheet.
Amazon DynamoDB is a fast and flexible fully managed NoSQL database service with predictable performance. It is designed to handle the most common data storage patterns, match the pace of modern development and scale cost efficiently.
Google Sheets is a Google spreadsheet application which allows users to manipulate, analyze and visualize data. The application has a variety of features that make it useful for businesses, such as the ability to share spreadsheets and collaborate with others in real time.
Create an account on Amazon Web Services and Google Cloud Platform if you don’t have an account already. (You can create a free trial account on both platforms. Go to the official Github repository of PynamoDB-to-Sheets and click on ‘Clone or Download’ button and then click ‘Download Zip’ option. Examine the contents of the zip file. There will be a folder named ‘pynamodb-to-sheets-master’ inside the zip file. From the command line, navigate to the folder ‘pynamodb-to-sheets-master’ and run the command ‘python setup.py install’. Using your preferred text editor, open the file ‘configuration.json’ in directory ‘configs’. Change the value of tableName from ‘test_table’ to your desired table name in DynamoDB. Change the value of serviceName from ‘aws’ to ‘gcp’ if you want to connect to your GCP project instead of your AWS account. Add your credentials for AWS (access key ID, secret access key. to configuration.json under the subheading ‘aws’ by replacing values associated with accessKeyId and secretAccessKey respectively. You can use either IAM roles or credentials file for authentication when connecting to GCP using AWS SDK for Python . Copy the sample credentials file located in directory ‘configs/credentials_file’ to ‘~/.aws/credentials’ in Linux or Mac OS X or ‘%userprofile%/.aws/credentials’ in Windows. Make sure that you change the values of region and output_bucket_name in configuration.json according to your settings. Create a new table in DynamoDB using AWS CLI tool by running the following command:
"aws dynamodb create-table --table-name <table name>"
Open either an existing Spreadsheet in Google Sheets or create a new one by clicking File->Make a new spreadsheet in Google Sheets. Change the value of ‘Destination Table’ under Advanced Settings tab in Google Sheets to match the name of your table created in DynamoDB. Select all data in your Spreadsheet(s. by clicking on the first cell and then pressing CTRL+A or CMD+A on Mac OS X. Click File->Google Drive->Export Unformatted Data… Under Destination tab, select your newly created table in DynamoDB and click OK. If you get an error message similar to one shown below, you may need to refresh your browser cache after exporting data from Google Sheets:
It should be noted that exporting data from Google Sheets into DynamoDB requires at least 700 MB of available space in your output_bucket_name bucket. While this step may consume some time depending on how much data you have exported, you can view progress of export operation by viewing output in CloudWatch. The last step is to import data from DynamoDB into Google Sheets by running the following command:
<path to python>/pynamodb2sheets -i -r -u <your spreadsheet email> -f <bucket> -t <table name> -w <worksheet name> --no-formula --no-duplicate --progress --no-header
The benefits of Integration of Amazon DynamoDB and Google Sheets are as follows:
The process to integrate Amazon DynamoDB and Google Sheets may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick solution to help you automate your workflows. Click on the button below to begin.