?>

Zoho Sheet + Amazon DynamoDB Integrations

Appy Pie Connect allows you to automate multiple workflows between Zoho Sheet and Amazon DynamoDB

  • No code
  • No Credit Card
  • Lightning Fast Setup
About Zoho Sheet

Zoho Sheet is a real-time spreadsheet app that lets you create, edit, share, and collaborate on spreadsheets in the cloud.

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.

Amazon DynamoDB Integrations
Amazon DynamoDB Alternatives

Looking for the Amazon DynamoDB Alternatives? Here is the list of top Amazon DynamoDB Alternatives

Best ways to Integrate Zoho Sheet + Amazon DynamoDB

  • Zoho Sheet Amazon DynamoDB

    Zoho Sheet + Amazon DynamoDB

    Create Item to Amazon DynamoDB from New Workbook in Zoho Sheet Read More...
    Close
    When this happens...
    Zoho Sheet New Workbook
     
    Then do this...
    Amazon DynamoDB Create Item
  • Zoho Sheet Amazon DynamoDB

    Zoho Sheet + Amazon DynamoDB

    Create Item to Amazon DynamoDB from New Worksheet in Zoho Sheet Read More...
    Close
    When this happens...
    Zoho Sheet New Worksheet
     
    Then do this...
    Amazon DynamoDB Create Item
  • Zoho Sheet Amazon DynamoDB

    Zoho Sheet + Amazon DynamoDB

    Create Item to Amazon DynamoDB from New Row in Zoho Sheet Read More...
    Close
    When this happens...
    Zoho Sheet New Row
     
    Then do this...
    Amazon DynamoDB Create Item
  • Zoho Sheet Amazon DynamoDB

    Zoho Sheet + Amazon DynamoDB

    Create Item from Amazon DynamoDB from Updated Column to Zoho Sheet Read More...
    Close
    When this happens...
    Zoho Sheet Updated Column
     
    Then do this...
    Amazon DynamoDB Create Item
  • Zoho Sheet Zoho Sheet

    Amazon DynamoDB + Zoho Sheet

    Create Worksheet to Zoho Sheet from New Table in Amazon DynamoDB Read More...
    Close
    When this happens...
    Zoho Sheet New Table
     
    Then do this...
    Zoho Sheet Create Worksheet
  • Zoho Sheet {{item.actionAppName}}

    Zoho Sheet + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect Zoho Sheet + Amazon DynamoDB in easier way

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

    Triggers
  • New Row

    Triggers when a new row is created in a specified worksheet.

  • New Workbook

    Triggers when a new workbook is created.

  • New Worksheet

    Triggers when a new worksheet is created in a specified workbook.

  • Updated Column

    Triggers when the value of a particular column is set on both new and updated rows. The corresponding row data is returned along with this trigger.

  • New Item

    Trigger when new item created in table.

  • New Table

    Trigger when new table created.

    Actions
  • Create Row

    Creates a new row in the specified worksheet.

  • Create Worksheet

    Creates a new worksheet in the specified workbook.

  • Delete Row

    Deletes a particular row based on its index.

  • Search Row

    Searches for a row/record in the specified worksheet based on some criteria.

  • Search and Delete Row

    Searches and then deletes a row based on some criteria

  • Search and Update Row

    Searches and then updates a row based on some criteria.

  • Update Row

    Updates a particular row based on its index.

  • Create Item

    Creates new item in table.

How Zoho Sheet & Amazon DynamoDB Integrations Work

  1. Step 1: Choose Zoho Sheet 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 Amazon DynamoDB 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 Zoho Sheet to Amazon DynamoDB.

    (2 minutes)

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

Integration of Zoho Sheet and Amazon DynamoDB

Zoho Sheet

Zoho Sheet is an online spreadsheet app which allows you to create and manage spreadsheets, charts and perform other tasks. It has more than 30 million users from around the world and is probably the most popular online spreadsheet app. Zoho Sheet supports all major browsers such as Chrome, Firefox, Internet Explorer, Safari, etc. (“Introduction to Zoho Sheet”.

Amazon DynamoDB

DynamoDB is a fully managed NoSQL database which provides fast and predictable performance with seamless scalability. It stores and accesses data items via their primary keys which are generated using the hash function. The DynamoDB tables are partitioned into multiple items which are stored on multiple servers. The DynamoDB system also manages the consistency of data across these servers in a distributed manner, this relieves the developer from making sure that the integrity of data is maintained at all times (“Introduction to Amazon DynamoDB”.

Integration of Zoho Sheet and Amazon DynamoDB

Integrating Zoho Sheet and Amazon DynamoDB can be done through two ways. Zoho Sheet REST API and Zoho Sheets App Scripts. Here we will use both of them to achieve maximum benefits. Integration through Zoho Sheet REST API allows us to modify the data in existing spreadsheets and tables. Integration through Zoho Sheets App Scripts allows us to create new spreadsheets and tables and perform various other functions.

Zoho Sheet REST API. This allows you to integrate with Zoho Sheet by creating a service account and providing it with permissions. You can do this by going to the “Manage Service Accounts” option on your Zoho Sheet dashboard and then clicking on the “Create New Service Account” button. Now, enter the credentials of your AWS account and add the relevant IAM rpes for the service account (“Integration with Amazon DynamoDB Using Zoho Sheet REST API”.

Zoho Sheets App Scripts. We can create new spreadsheets by using App Scripts in Zoho Sheets. To use app scripts, go to Tops > Script Editor on your Zoho Sheets dashboard. Now, click on the “Create New Project” button and enter a name for your project. After you have created your project, click on the ‘View App Script Code’ button. Now, paste the given code into the code editor window (“Integration with Amazon DynamoDB Using Zoho Sheets App Scripts”.

Zoho Sheet REST API. This enables us to leverage our Zoho Sheet spreadsheets with Amazon DynamoDB in many ways. For example, if we have a spreadsheet named ‘Users’ with cpumns like Username, Password, First Name, Last Name, Email Address, etc., we can create a User table in Amazon DynamoDB with corresponding cpumns. The username cpumn in this case would be the primary key of this table. Whenever we want to add a new row into this table, we can update the corresponding cell in our Users spreadsheet. We can do this by using the fplowing code:

var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1N8R_vAiV7NlZHdwWKq8qcL-Vd99nTtCdtb7g8rjJG0YI/edit#gid=0"); var sheet = ss.getSheetById("Users"); var row = sheet.getLastRow(); for (var i = 1; i <= row; i++. { if (sheet.getRange(i, 1. == "Username". { sheet.getRange(i, 0.setValue("testuser"+i); } } 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 var ss = SpreadsheetApp . openByUrl ( "https://docs.google.com/spreadsheets/d/1N8R_vAiV7NlZHdwWKq8qcL-Vd99nTtCdtb7g8rjJG0YI/edit#gid=0" . ; var sheet = ss . getSheetById ( "Users" . ; var row = sheet . getLastRow ( . ; for ( var i = 1 ; i <= row ; i ++ . { if ( sheet . getRange ( i , 1 . == "Username" . { sheet . getRange ( i , 0 . . setValue ( "testuser" + i . ; } }

After we have updated the spreadsheet cells, we can create a query in our User table with corresponding values from these cells as shown below:

SELECT * FROM usertable WHERE Username = 'testuser' LIMIT 1 1 SELECT * FROM ` usertable ` WHERE ` Username ` = 'testuser' LIMIT 1

To see the results of this query, right-click on it and choose ‘Run Query’ as shown below:

Now, when you try to run this query, you will see that this query returns one value only because we have only one row in our table with username as testuser1 (“Integration with Amazon DynamoDB Using Zoho Sheet REST API”. We can also add new rows into our table by pasting new values into the cpumns of our table and selecting ‘Run Query’ again. This will add a new row into our table with all the selected values from our spreadsheet:

If we want to update any of the values in our table, we can use the fplowing script to update these values using our spreadsheet:

var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1N8R_vAiV7NlZHdwWKq8qcL-Vd99nTtCdtb7g8rjJG0YI/edit#gid=0"); var sheet = ss.getSheetById("Users"); var row = sheet.getLastRow(); for (var i = 1; i <= row; i++. { if (sheet.getRange(i, 1. == "Username". { var id = i; var body = "; body += "Username = 'testuser"+id+"' AND Password`='passw0rd'"; documentService.updateDocument({ userId. id }, body); } } 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 var ss = SpreadsheetApp . openByUrl ( "https://docs.google.com/spreadsheets/d/1N8R_vAiV7NlZHdwWKq8qcL-Vd99nTtCdtb7g8rjJG0YI/edit#gid=0" . ; var sheet = ss . getSheetById ( "Users" . ; var row = sheet . getLastRow ( . ; for ( var i = 1 ; i <= row ; i ++ . { if ( sheet . getRange ( i , 1 . == "Username" . { var id = i ; var body = " ; body += "`Username = 'testuser" + id + "' AND `Password`='passw0rd'" ; documentService . updateDocument ( { userId . id } , body . ; } }

This script uses the updateDocument method of our documentService object which takes two parameters. userId and body. The userId parameter is used to identify the user whose password needs to be changed while the body parameter is used to send a request to change this password. As you can see from the script above, we have changed the password of testuser1 to passw0rd by adding it into the body parameter of our request and sending it to documentService.updateDocument(. method of our DocumentService object. Once our request has been received by documentService, it will search for any documents having username equal to testuser1 or username equal to testuser2 in our User table and update their passwords by replacing their current values

The process to integrate Zoho Sheet and Amazon DynamoDB may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.