We can connect our Clappia apps to Google Drive so that all submissions get synced to Google Sheets and all images and files get synced to Google Drive in real-time. The connected Google Drive gets updated on the following events:
1. New Submissions
2. Submission edits
3. Status change
4. Submission deletes
5. Bulk upload of data
Here are the steps to connect Clappia apps to Google Drive:
1. Sign in to Clappia and select the app you wish to connect with to Google Drive. Go to the ‘Design App’ tab and click on ‘Configuration’.
Then click on the ‘Google Sheets/Drive’ button.
2. On the right panel, enable the option and click on the button Connect with Google Sheets/Drive. This will take you to Google Account authentication.
3. You will get a Google Sign In prompt. Select your Google Account or and Sign-in to your Google Account.
Click on allow. This will authorize Clappia to write data to the Google Drive and you are done.
Note: In case you get an error message while connecting to Google Drive, try checking your browser settings or updating your browser.
4. Once connected successfully, the right panel will be updated with syncing options. You can click on Show Google Sheets and Show Google Drive Folders option to view the connected Sheet and Folder.
Existing submissions of the app will get synced to Google Sheets and all submission events after this step will also update the Sheet in real-time. Any images or files data will be synced only for new submissions. Old image data cannot be back-filled.
After connecting your app to Google Sheets or Drive, you have the flexibility to control which fields from your submissions are synced.
In the right panel, under Columns Selected, click the dropdown. You will see a list of all fields currently available in your app's submissions.
Deselect any fields you do not want to sync to your Google Sheet.
Once you make your selections, click Save & Resync. A success message will appear confirming the changes.
Only the selected fields will be visible in your connected Google Sheet.
Note:
When your app submissions include files such as images, videos, or documents, Clappia can automatically upload these files to the connected Google Drive. This ensures that all file attachments from submissions are stored securely and are easy to access later.
After enabling Google Sheets/Drive integration, you can enable the “Sync Images and Other Files” option from the right panel. Once this option is turned on:
Note:
Files (images, videos, documents) are only pushed to Google Drive for new submissions made after the integration is enabled.
Submissions created before enabling this feature or during periods when the feature is disabled will not automatically sync their files to Google Drive.
Workaround:
You can manually download these files from the Submissions tab. Use filters (e.g., by submission date) to find the files corresponding to the time when Drive integration was disabled, then upload them manually to your Google Drive.
If your app generates PDF documents using print templates, you can enable Clappia to automatically save these PDFs to your connected Google Drive folder.
By enabling the “Sync Print Templates” option in the right panel:
Note:
PDFs from print templates are only pushed to Google Drive for new submissions made after enabling this feature. Older submissions will not sync their PDFs automatically. You can download them manually from the Submissions tab and upload them to Google Drive if needed.
When submissions in your Clappia app include files (such as images, videos or PDFs from print template), these files are automatically stored in a Google Drive folder named after your app’s ID (e.g., AppID).
With the File Path setting, you can create a custom folder structure within this main AppID folder. This helps you organise files based on submission data instead of having all files stored in a single location.
How it works:
How to set it up:
Example Scenario:
If your app contains dropdown fields named Country and State, having same variable names, and you set the File Path as:
{$app_id}/{country}/{state}
Then, a file uploaded by a user in the submission, selecting the dropdown named country as ‘India’ and state as ‘Karnataka’, will be saved like this:
AppID/India/Karnataka/
This approach is especially useful for apps that manage data from multiple regions, projects, or categories, as it keeps files neatly separated and easy to find.
Note on Subfolder Retention:
If you define a folder path using field variables (e.g., {$app_id}/{country}/{state}), Clappia creates subfolders inside the main AppID folder based on those field values.
If you later delete that field (e.g., state) from the app or remove it from the File Path, the corresponding subfolders and files will not be deleted automatically. These subfolders will remain in your Google Drive.
You can manually delete these subfolders if needed, but ensure you download or back up their files first to avoid data loss.
1. Google Sheets can support up to a maximum of 5,000,000 cells. So if a Clappia App has 10 fields, then every app submission will occupy 10 cells and so up to 500,000 submissions will be accommodated in the Google Sheets. The number of supported submissions will keep reducing as the number of fields in the app increase.
2. On disconnecting the Google Sheets once, the Sheet is deleted from the user's account and on connecting again, a new Sheet will be created. So it is not possible to pause the sync by disconnecting for some time and then connecting again.
3. If there are any changes in the structure of the app, like field additions/removals, Google Sheets need to be disconnected and connected again. This is because the Header Row of the Sheet gets fixed on the initial connection and it never changes.
4. If you want to create more sheets that have dependencies on the connected Sheet, it is advisable to do so in a separate Google Sheet, not as a sub-sheet of the connected Sheet. You can use the IMPORTRANGE function to do this. Otherwise you run into the risk of the entire sheet getting deleted if an App Admin disconnects the Google Sheet from the App.
5. If you are having multiple print templates then only the first one will be synced to the Google Drive folder, as of now.
L374, 1st Floor, 5th Main Rd, Sector 6, HSR Layout, Bengaluru, Karnataka 560102, India
3500 S DuPont Hwy, Dover,
Kent 19901, Delaware, USA
3500 S DuPont Hwy, Dover,
Kent 19901, Delaware, USA
L374, 1st Floor, 5th Main Rd, Sector 6, HSR Layout, Bengaluru, Karnataka 560102, India