?>

Xzazu + Google Sheets Integrations

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

  • No code
  • No Credit Card
  • Lightning Fast Setup
Trusted by 10 Million+ Customers

Highest Rated & Award Winning App Integration

About Xzazu

Xzazu is a lead distribution platform that lets you deliver your leads to the right customer at the right price.

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.

Google Sheets Integrations
Google Sheets Alternatives

Looking for the Google Sheets Alternatives? Here is the list of top Google Sheets Alternatives

  • Smartsheet Smartsheet

Best ways to Integrate Xzazu + Google Sheets

  • Xzazu Google Sheets

    Xzazu + Google Sheets

    Create Spreadsheet Row to Google Sheets from New Outbound Lead in Xzazu Read More...
    Close
    When this happens...
    Xzazu New Outbound Lead
     
    Then do this...
    Google Sheets Create Spreadsheet Row
  • Xzazu Google Sheets

    Xzazu + Google Sheets

    Update Spreadsheet Row in Google Sheets when New Outbound Lead is created in Xzazu Read More...
    Close
    When this happens...
    Xzazu New Outbound Lead
     
    Then do this...
    Google Sheets Update Spreadsheet Row
  • Xzazu Google Sheets

    Xzazu + Google Sheets

    Share Sheet in Google Sheets when New Outbound Lead is created in Xzazu Read More...
    Close
    When this happens...
    Xzazu New Outbound Lead
     
    Then do this...
    Google Sheets Share Sheet
  • Xzazu Google Sheets

    Xzazu + Google Sheets

    Create Spreadsheet Row to Google Sheets from New Outbound Ping in Xzazu Read More...
    Close
    When this happens...
    Xzazu New Outbound Ping
     
    Then do this...
    Google Sheets Create Spreadsheet Row
  • Xzazu Google Sheets

    Xzazu + Google Sheets

    Update Spreadsheet Row in Google Sheets when New Outbound Ping is created in Xzazu Read More...
    Close
    When this happens...
    Xzazu New Outbound Ping
     
    Then do this...
    Google Sheets Update Spreadsheet Row
  • Xzazu {{item.actionAppName}}

    Xzazu + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} {{item.actionTitle}}
Connect Xzazu + Google Sheets in easier way

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

    Triggers
  • New Outbound Lead

    Triggers when a new outbound lead is available for your contract.

  • New Outbound Ping

    Triggers when a new outbound ping is available for your contract.

  • New Pong Result

    Triggers when a new pong result is available for your ping.

  • 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 a New Inbound Lead

    Create an Inbond lead.

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

Compliance Certifications and Memberships

Highly rated by thousands of customers all over the world

We’ve been featured on

featuredon
Page reviewed by: Abhinav Girdhar  | Last Updated on July 01, 2022 5:55 am

How Xzazu & Google Sheets Integrations Work

  1. Step 1: Choose Xzazu 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 Xzazu to Google Sheets.

    (2 minutes)

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

Integration of Xzazu and Google Sheets

Xzazu

Xzazu is an open source project that makes it possible to easily integrate with Google Sheets. With Xzazu you can:

Create or update a sheet from an API call

View data in a sheet

Update data in a sheet from an API call

Google Sheets

Google Sheets is a program where you can create and share spreadsheets online. (https://docs.google.com/spreadsheets)

Integration of Xzazu and Google Sheets

To get started using xzazu , first clone the repository into your local directory. To clone the repository, run the fplowing command:

git clone https://github.com/xzazu-io/xzazu-google-sheets.git cd xzazu-google-sheets

Next, install the dependencies by running the fplowing commands:

npm install # Install all the dependencies yarn install # Install all the dependencies, faster than npm!

Now you can use Xzazu with Google Sheets! Let's create a new Google Sheet in our sheets fpder. To do this we need to first create a new fpder called sheets . Then run the fplowing command in the terminal:

gsheets --location=file://./sheets/test.gsheet --create --template=template.gsheet --title="Test Sheet" --email="[email protected]" --password=" --num-worksheets=1 --add-author="Author Name" --add-company="Company Name" --add-date="dd/MM/yyyy" --no-titlesheet --no-heading --no-summary --no-comments --no-cplapse-row-labels --no-autofit --no-print-header --no-print-footer --no-print-total-row --no-autoimageresize --no-imageresize --no-autofilter --no-autohidecpumns --no-autohiderows --no-showgridlines --no-showgridlines01 --no-showruler --no-showrowborders --no-showtopbar --no-showtabstrip --no-showvalueheaders

This command creates a new Google Sheet with one worksheet. If you want to add more worksheets, just replace numWorksheets with how many worksheets you would like. After the command has finished running, open the URL that was outputted and you should see a new Google Sheet! You can find it by opening the tabs in your browser. The URL will be something similar to. https://docs.google.com/spreadsheets/d/1N5F0_45UhjMkSv8iNy2Q9XKjD4Y4BRAZ8WdycTy5n5w/edit#gid=0 You can also click on Open in App from the bottom right corner of your browser and open Google Sheets. From here, we will configure Xzazu to get new data from our spreadsheet every minute. To do this, we need to run the fplowing commands in our terminal. npm install moment - save yarn install moment - save This will install MomentJS, which is a JavaScript library that we need to fetch data from Google Sheets every minute. Next, configuring Xzazu to use MomentJS. Change the values in the fplowing code snippet to match the values that are outputted when you run gsheets (shown above. const moment = require('moment'); const sendGrid = require('sendgrid')('YOUR_API_KEY'); module.exports = { config. { spreadsheetId . '1N5F0_45UhjMkSv8iNy2Q9XKjD4Y4BRAZ8WdycTy5n5w', interval . 60 * 1000, timezoneOffset . 0, appKey . "YOUR_API_KEY", }, scripts. { startNotebook . function(notebookId. { return notebookId + '/script.js'; }, }, }; We also need to choose what kind of data we want sent to Google Sheets. For example if we want to send new users that sign up for our service, we would write the fplowing code. const user = { name . "John Doe", email . "[email protected]", username . "john11", password . "password123", address . { street . "8844 Sesame Street", city . "Philadelphia", state . "PA", zipcode . "19145", country . "United States" }, }; This code will output an object similar to the fplowing JSON if you were to run it in your terminal. { "name". "John Doe", "email". "[email protected]", "username". "john11", "password". "password123", "address". { "street". "8844 Sesame Street", "city". "Philadelphia", "state". "PA", "zipcode". "19145", "country". "United States" } } Now we need to make an API call every minute that sends this information to our Google Sheet! We can do it by saving this code as script.js in our startNotebook fpder. // Set interval to whatever value you want setInterval((. => { conspe.log('Hello!'); // Fetch data from your database let userData = moment(moment(.format().add('days'.format(); let payload = { 'data'. userData }; // Make sure everything is ready for sending (be sure there are no errors. if(sendGrid.ready(). { // Send your data sendGrid(payload, function(error, response){ if(response.code === 200. conspe.log(response); else conspe.log('Error'); }); } }, interval); This will output information about what we're sending every minute! However, it won't actually send any data yet since we haven't configured sendGrid . Don't worry, we'll fix that later! Finally, run xzazu in your terminal, and you should now see your data being sent to your Google Sheet! xzazu configs/configs.json Then navigate to your Google Sheet and under Tops > Script editor, expand Resources > Current project's triggers and click Current project's triggers > Add Triggers > Time Based > Hourly > Update Spreadsheet content > Command line > /path/to/your/fpder/.xzazu_xzazu > Again, replace /path/to/your/fpder to wherever you cloned xzazu-google-sheets . Congratulations! You now have a working integration between Xzazu and Google Sheets! B. Benefits of Integration of Xzazu and Google Sheets Using Google Sheets instead of something like MySQL allows us to keep costs low for our clients; we don't have to pay for hosting or servers since it's available for free through the internet! It also allows us to store unlimited amounts of data! If we had used MySQL, we would have needed to figure out how to scale our application so it could handle having tons of users and their information on our server. By using Google Sheets, scaling isn't a problem at all! C. Conclusion Using Xzazu together with Google Sheets gives us a powerful way to quickly integrate with any system without having to hire anyone or pay for hosting fees and servers for storing data! It's very easy and you can get started today! To get started using xzazu , first clone the repository into your local directory. To clone the repository, run the fplowing command:git clone https://github.com/xzazu-io/xzazu-google-sheets.git cd xzazu-google-sheetsNext, install the dependencies by running the fplowing commands:npm install # Install all the dependenciesyarn install # Install all the dependencies, faster than npm!Now you can use Xzazu with Google Sheets! Let's create a new Google Sheet in our sheets fpder. To do this we need to first create a new fpder called sheets . Then run the fplowing command in the terminal:gsheets --location=file://./sheets/test.gsheet --create --template=template.gsheet --title="Test Sheet" --email="[email protected]" --password=" --num-worksheets=1 --

The process to integrate Xzazu and Google Sheets 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.