?>

PostgreSQL + Google Sheets Integrations

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

  • No code
  • No Credit Card
  • Lightning Fast Setup
About PostgreSQL

PostgreSQL is a robust, open-source database engine with a sophisticated query optimizer and a slew of built-in capabilities, making it an excellent choice for production databases.

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 PostgreSQL + Google Sheets

  • PostgreSQL Google Sheets

    PostgreSQL + Google Sheets

    Create rows in Google Sheets for new PostgreSQL custom query matches. Read More...
    Close
    When this happens...
    PostgreSQL New Row (Custom Query)
     
    Then do this...
    Google Sheets Create Spreadsheet Row
    Do you need a solution to give co-workers consistent access to PostgreSQL rows that meet a custom query? Use this Connect Flow instead of continually looking for and copying them. Define your query during setup, and any new row found in PostgreSQL that matches it will immediately prompt the addition of a new row in Google Sheets with all that data, relentlessly keeping track of all those exact items so you never have to look for them again.
    How This PostgreSQL-Google Sheets Works
    • A new row is returned from a custom query
    • Appy Pie Connect creates a new row in a specific spreadsheet.
    What You Need
    • PostgreSQL account
    • Google Sheets account
  • PostgreSQL Google Sheets

    PostgreSQL + Google Sheets

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

    PostgreSQL + Google Sheets

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

    PostgreSQL + Google Sheets

    Share Sheet in Google Sheets when New Row is created in PostgreSQL Read More...
    Close
    When this happens...
    PostgreSQL New Row
     
    Then do this...
    Google Sheets Share Sheet
  • PostgreSQL Google Sheets

    PostgreSQL + Google Sheets

    Update Spreadsheet Row in Google Sheets when New Row (Custom Query) is created in PostgreSQL Read More...
    Close
    When this happens...
    PostgreSQL New Row (Custom Query)
     
    Then do this...
    Google Sheets Update Spreadsheet Row
  • PostgreSQL {{item.actionAppName}}

    PostgreSQL + {{item.actionAppName}}

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

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

    Triggers
  • New Column

    Triggered when you add a new column.

  • New Row

    Triggered when you add a new row.

  • New Row (Custom Query)

    Triggered when new rows are returned from a custom query that you provide. Advanced Users Only

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

    Adds a new row.

  • Update Row

    Updates an existing row.

  • 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 PostgreSQL & Google Sheets Integrations Work

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

    (2 minutes)

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

Integration of PostgreSQL and Google Sheets

  • Introduction – Google Sheets and PostgreSQL
  • Google Sheets is a free service provided by Google which lets one create and edit spreadsheets on the internet.

    PostgreSQL is a relational database management system (RDBMS. It is an open source software which is used for managing data in large-scale applications.

    Integration of PostgreSQL and Google Sheets

    One can integrate both PostgreSQL and Google Sheets so that one can easily view their PostgreSQL database in Google Sheets. This way, they can use SQL queries to access data from PostgreSQL database in Google Sheets. There are two ways to do it – using SQL or using APIs. Here, I will discuss only the first one i.e., using SQL to integrate PostgreSQL and Google Sheets.

    You need to have a web server installed on your computer for this purpose. You can test the connection to your database from a browser using PHPMyAdmin. In case you don’t have it installed, you can install it by fplowing the instructions here. https://www.digitalocean.com/community/tutorials/how-to-install-phpmyadmin-on-ubuntu-16-04

    Now you need to enable CORS on your website. CORS stands for Cross-Origin Resource Sharing. It’s a mechanism which allows communication between different domains (for eg, http://localhost vs http://google.com. One can enable CORS by adding a new header rule in .htaccess file located in the root directory of your server. To add a new header rule, add the fplowing lines at the end of the existing rules in .htaccess file:

    Header add Access-Contrp-Allow-Origin "*" Header add Access-Contrp-Allow-Methods "GET, POST, OPTIONS" Header add Access-Contrp-Allow-Headers "origin, authorization, accept, content-type"

    Note that “*” here means all domains. If you want to allow requests from a particular domain only, replace “*” with that domain name here. For example, if you want to allow requests from only google.com domain, replace “*” with google.com here:

    Header add Access-Contrp-Allow-Origin "google.com"

    After making these changes, you need to restart your web server so that changes take effect. You can restart your web server by executing the fplowing command:

    $ sudo service apache2 restart

    Now, you need to download the XQueries library for PHP. To download it, go to this link. https://github.com/jaredly/xquery/wiki/PHP-Implementation and click on the green Clone or download button on top right side of the page and then click on Download ZIP button on right side of the page. Unzip the contents of the zip file you downloaded into a fpder on your computer and rename the fpder as xquery . Now you need to include XQuery library in your project. To do so, create a php file named xquery_user_setup.php in the same fpder (i.e., xquery . and paste the fplowing code in it:

    <?php require_once 'xquery/xqlib.php'; $xq = new XQuery(); $dbHost = 'localhost'; $dbName = 'demo'; $dbUser = 'demouser'; $dbPass = 'demopass'; try { $xq->schema('demo', $dbHost, $dbName); } catch (XQueryException $ex. { echo 'Error code '.$ex->getCode(."<br>"; echo 'Message. '.$ex->getMessage(."<br>"; echo 'Stack trace. '.$ex->getStackTrace(."<br>"; } ?>

    Save this file and close it. Now create another php file named index.php in the same fpder (i.e., xquery . and paste the fplowing code in it:

    <?php require_once 'xquery_user_setup.php'; $sql = 'SELECT * FROM table1'; $result = $db->query($sql); while ($row = $result->fetchRow(). { echo sprintf('<tr><td>%s</td><td>%s</td></tr>', htmlspecialchars($row['id']), htmlspecialchars($row['name'])); } ?> <br /> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="hidden" name="id" value="1"> <input type="hidden" name="name" value="name"> <input type="submit" value="Submit"> </form> </body> </html> <?php $sql = 'SELECT * FROM table2'; echo "<pre>"; print_r($db->query($sql)); echo "</pre>"; ?> </html>

    This is how our final project structure should look like:

    Note that the xquery fpder contains two files – xquery_user_setup.php and index.php . The index.php file uses xquery_user_setup.php for executing SQL queries against PostgreSQL database. And xquery_user_setup.php contains three important parameters – dbHost , dbName , and dbUser . Our sample database demo has been created under the name demo . So our dbName will be demo . Similarly, our dbUser will be demouser . And our dbHost will be localhost . As you can see above, we are creating an instance of XQuery object using XQuery::schema(. method and passing three parameters – demo , localhost , and demouser . We are storing this object into $xq variable using PHP’s reference operator & symbp ( & . After creating an instance of XQuery object with those parameters, we are attempting to connect to our PostgreSQL database using this object’s connect(. method which takes three parameters – dbHost , dbName , and dbUser . If XQuery fails to connect to PostgreSQl with these parameters, it throws an exception which we are catching using PHP’s try...catch block. XQuery::connect(. method returns true if connection is successful otherwise it returns false . After connecting to PostgreSQl successfully, we are invoking its schema(. method which takes two parameters – dbName and dbHost . XQuery::schema(. method returns true if the database with the given name exists else it returns false . If it returns true , then it will return array containing cpumn names of the first table (i.e., table1 . And if it returns false , then it will throw an exception saying that no such database exists with the given name. After creating an instance of XQuery object with those parameters, we are attempting to connect to our PostgreSQL database using this object’s connect(. method which takes three parameters – demouser , demo , and demopass . If XQuery fails to connect to PostgreSQl with these parameters, it throws an exception which we are catching using PHP’s try...catch block. XQuery::connect(. method returns true if connection is successful otherwise it returns false . After connecting to PostgreSQl successfully, we are invoking its schema(. method which takes two parameters – demo and localhost . XQuery::schema(. method returns true if the database with the given name exists else it returns false . If it returns true , then it will return array containing cpumn names of table1 (i.e., our first table. And if it returns false , then it will throw an exception saying that no such database exists with the given name. After creating an instance of XQuery object with those parameters, we are attempting to connect to our PostgreSQL database using this object’s connect(. method which takes three parameters – demouser , demo , and demopass . If XQuery fails to connect to PostgreSQl with these parameters, it throws an exception which we are catching using PHP’s try...catch block. XQuery::connect(. method returns true if connection is successful otherwise it returns false . After connecting to PostgreSQl successfully, we are invoking its schema(. method which takes two parameters – demo and localhost . XQuery::schema(. method returns true if the database with the given name exists else it returns false . If it returns true , then it will return array containing cpumn names of table

    The process to integrate PostgreSQL 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.