A regular question we get at Pliik is: Can Pliik import my data from a spreadsheet?
If you’re able to get your data into a spreadsheet format like an Excel or CSV file, you can use Google Sheets as an intermediary app in creating a Zap that mimics an import function.
Here is how it works.
1. Set up the Google Sheets spreadsheet
First, export your data from your first app into a format like a CSV file. In Row 1, copy in the column headers from your imported spreadsheet file:
2. Create the Pliik & Google Sheets Zap
Under settings in Pliik, copy your Team ID, you’ll need it to create the zap.
Create a new Zap. When you set up the trigger, select Google Sheets as the app and select New Spreadsheet Row as the trigger event. Select the new Google Sheets spreadsheet that you’ve created in the first step.
3. Copy your data to your Google Sheet
Now that your Zap is turned on, you can copy the remaining data from the imported spreadsheet into the Google Sheet spreadsheet. Make sure that you’re properly pasting the data to the right columns. After you’ve copied your data into the spreadsheet, the Zap you’ve created will trigger from these newly-added rows.