Skip to main content

Google Sheets

This guide contains information to set up a Google Sheets Sink in Vanus Connect.

Introduction​

Google Sheets is a powerful spreadsheet tool that can be used to store and analyze data.

With Google Sheets Sink connector in Vanus Connect, you can easily forward real-time updates to a designated sheet in your Google Sheets account, allowing you to track events generated by your application.

Prerequisites​

Before forwarding events to Google Sheets, you must have:

Getting Started​

To set up a Google Sheets Sink in Vanus Connect:

Step 1: Create a Google Spreadsheet​

  1. Go to Google Sheets and Sign in.

  2. Create a new Blank① spreadsheet.

google-sheets-1

  1. Copy the Spreadsheet URL②.

google-sheets-2

Step 2: Google Sheets Connection Settings​

  1. Click on Sign in with Google① and follow the process to sign in to your Google account.

google-sheets-3

  1. Obtain the name of the Sheet② at the bottom of the spreadsheet.

google-sheets-4

  1. Return to Vanus Cloud and complete your configuration.

  • Paste the Spreadsheet URL③ that was copied from Step 1.

  • Paste the Sheet Name④: Sheet1.

google-sheets-5

Step 3: Personalize Event Structure​

note

This is a general instruction on how to personalize your event structure. You can structure your events to suit your specific requirements and create connections for different scenarios.

  1. Click on Display sample events① for reference and click on Add More② to add events.

google-sheets-6

  1. Input key③ and search for the corresponding value④ for the event you want.

google-sheets-7

  1. You can fill in as many key-value pairs⑤ as you wish to receive.

google-sheets-8

  1. Click Submit⑥ to finish the configuration process.

google-sheets-9

Required Data Format​

The event data must be in JSON format with the following keys:

{
    "Title": "value",
    "date": "value",
    "ect...": "value"
}