Data2Sheets

Transfer your data seamlessly with Data2Sheets

The application transfers your data from any database to a Google Spreadsheet through REST API methods.

One method: https://app.data2sheets.com/rest/method/add

Required properties:

• token (to authenticate access to the REST API)
• data (associative array with incrementing values)
• spreadsheet
  • id - (ID of the table that will be used as data destination)
• params (additional options)
  • key (row/cell ID for data update/edit)
  • addColumns (to add new rows that are missing in the data export)
  • deleteRows (to delete rows that are missing in the data export)
  • copyFormula (to copy formulas from parameters)

Your data is secure

The application has access only to a limited dataset to secure your data safety

• Your registration data
  • email
  • password
• Google authentification data

The application doesn't save or store any of the data transferred to your document.

Set up your first data transfer

Registration

Step 1. Sign up to create your account

Synchronization

Step 2. Sync your Google account

Token Generation

Step 3. Generate a token to access the REST API

Unloading

Step 4. Pass data within REST API requests