User Guide: Power Sync
With Power Sync you can sync your Podio app to a Google Sheet. This opens the door to a ton of extra possibilities to build dynamic reports, graphs and pivot tables on top of your Podio data. It also allows you to connect your Podio to the powerful features of Google Datastudio.
Create new sync
Click on the Power Sync icon and click on 'Add new sync' to get started.
Select the fields that you want to sync
First select the fields that you want to sync. By default we will select all the fields that are displayed in your view. The drop-down will show all fields of your app.
Enter a name for your google sheet
After selecting the columns, you can enter name for your google sheet. The name will make it easier for future use to distinguish it from other power syncs. (It is possible to create more than 1 power sync for the same Podio app.)
Start Power Sync
Click on 'Start Sync' to create the google sheet. The progress bar will show the progress of the initial creation and sync. Once the sync is completed, you can click on 'Go To Sheet' to open the google sheet.
Important: Momentum will automatically sync the values from the Podio app every 10 minutes to the google sheet.
Active Power Syncs
Once you have created a Power Sync, new section will appear in the toolbox with your 'Active Power Syncs'. This overview allows you to:
- Open the google sheet
- Refresh the sheet manually
- Remove the google sheet (cannot be undone!)
Important: The data in the 'Export' sheet cannot be edited, however it is possible to build reports on top of this main sheet (see below).
The created google sheet allows you to leverage all of Google Sheets features. A few examples: