Integrate Amazon DynamoDB with Google Sheets

Appy Pie Connect allows you to automate multiple workflows between Amazon DynamoDB and Google Sheets

  • No code
  • No Credit Card
  • Lightning Fast Setup

20 Million work hours saved

Award Winning App Integration Platform

About Amazon DynamoDB

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.

About Google Sheets

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

  • JotForm Integration JotForm
  • Airtable Integration Airtable
  • Smartsheet Integration Smartsheet
  • ClickUp Integration ClickUp
  • Basecamp Classic Integration Basecamp Classic
  • Zoho Sheet Integration Zoho Sheet
  • Microsoft Excel Integration Microsoft Excel
Connect Amazon DynamoDB + Google Sheets in easier way

It's easy to connect Amazon DynamoDB + Google Sheets without coding knowledge. Start creating your own business flow.

  • Triggers
  • New Item

    Trigger when new item created in table.

  • New Table

    Trigger when new table created.

  • New Spreadsheet

    Triggers once a new spreadsheet is created.

  • New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

  • New or Updated Spreadsheet Row

    Trigger when a new row is added or modified in a spreadsheet.

  • Actions
  • Create Item

    Creates new item in table.

  • Create Update Item

    Create a new item or updates an existing item.

  • Create Spreadsheet Row

    Insert a new row in the specified spreadsheet.

  • Create Update Spreadsheet Row

    Create a new spreadsheet row or Update an existing row.

  • Share Sheet

    Share Google Sheet.

  • Update Spreadsheet Row

    Update a row in a specified spreadsheet.

How Amazon DynamoDB & Google Sheets Integrations Work

  1. Step 1: Choose Amazon DynamoDB as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Google Sheets as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from Amazon DynamoDB to Google Sheets.

    (2 minutes)

  6. Your Connect is ready! It's time to start enjoying the benefits of workflow automation.

Integration of Amazon DynamoDB and Google Sheets

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.

Integration of Amazon DynamoDB and Google Sheets is beneficial for both – Amazon DynamoDB and Google Sheets. Integration can be achieved using an open source library called PynamoDB-to-Sheets. This library allows users to seamlessly transfer data from Amazon DynamoDB to Google Sheets. Using this library, users are able to move data from DynamoDB to Google Sheets in batch or single operation. The library is also non-cached meaning that all requests, including large ones, are served directly by AWS. Step-by-step instructions for integration follow:

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 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.

Page reviewed by: Abhinav Girdhar  | Last Updated on November 09,2022 06:11 pm