Learn how to automate the process of uploading images from Google Forms to Google Slides and sending them via WhatsApp using Pabbly Connect in this detailed tutorial.
Watch Step By Step Video Tutorial Below
1. Accessing Pabbly Connect for Automation
To start automating the process of uploading images in Google Slides from Google Forms and sending them via WhatsApp, first, access Pabbly Connect. Visit the Pabbly website and either sign in or sign up for a free account, which allows you to get free tasks every month. Signing up is essential for using the automation features.
Once you are logged in to Pabbly Connect, navigate to the ‘Create Workflow’ button located at the top right corner. You will need to name your workflow, such as ‘How to Upload Image in Google Slide from Google Forms and Send on WhatsApp’. This naming helps in identifying your automation easily later.
2. Setting Up Google Forms as a Trigger in Pabbly Connect
In this step, we will configure Google Forms as the trigger application in Pabbly Connect. Select Google Forms as your trigger application and choose the event ‘New Response Received’. This event will initiate the automation process whenever a new response is submitted through your Google Form.
- Select Google Forms as the trigger application.
- Choose ‘New Response Received’ as the trigger event.
- Copy the provided webhook URL.
Next, go to your Google Form, click on the responses tab, and create a new Google Sheet to capture these responses. After that, navigate to the ‘Extensions’ menu in Google Sheets, select ‘Pabbly Connect Webhooks’, and then click on ‘Initial Setup’. Paste the copied webhook URL here and specify the trigger column, which in this case will be the image upload column.
3. Configuring Google Drive to Share the Uploaded Image
After setting up the trigger, the next step involves configuring Google Drive as an action in Pabbly Connect. Select Google Drive as the action application and choose the action event ‘Share a File with Anyone’. This step is crucial as it makes the uploaded image accessible for later use in Google Slides.
Connect your Google Drive account and then map the file ID from the previous Google Forms response. If the file ID is not directly available, use a text formatter step to extract it from the image URL. This can be done by splitting the URL at the equal sign and taking the last segment, which contains the file ID.
- Select Google Drive as the action application.
- Choose ‘Share a File with Anyone’ as the action event.
- Map the file ID extracted from the previous step.
Once you have successfully shared the file, you can proceed to the next steps in the automation process.
4. Uploading the Image to Google Slides with Pabbly Connect
In this section, we will use Pabbly Connect to upload the image to Google Slides. Select Google Slides as the next action application and choose the action event ‘Create Presentation from Template’. This allows you to create a new presentation using a pre-defined template.
After connecting your Google Slides account, choose the template you want to use for the presentation. For example, if you are using an ‘Academy Awards’ template, select it and map the student’s name from the Google Forms response to the appropriate field in the presentation.
Select Google Slides as the action application. Choose ‘Create Presentation from Template’ as the action event. Map the student’s name and the image link to the template.
After completing this step, you will have a Google Slides presentation ready with the uploaded image and student details.
5. Sending the Certificate via WhatsApp Using Pabbly Connect
Finally, to send the generated certificate via WhatsApp, select WhatsApp Cloud API as the action application in Pabbly Connect. Choose the action event ‘Send Template Message’. Here, you will need to connect your WhatsApp account and provide the necessary authentication details such as the temporary access token, phone number ID, and WhatsApp Business account ID.
After setting up the connection, map the recipient’s phone number and the document URL generated from the previous steps. This ensures that the student receives their certificate directly on WhatsApp. Once everything is mapped correctly, send a test request to verify that the message is sent successfully.
Select WhatsApp Cloud API as the action application. Choose ‘Send Template Message’ as the action event. Map the necessary details including the document URL.
With this final step completed, the automation process is fully functional, allowing you to upload images from Google Forms to Google Slides and send them via WhatsApp seamlessly using Pabbly Connect.
Conclusion
This tutorial has detailed how to automate the process of uploading images from Google Forms to Google Slides and sending them via WhatsApp using Pabbly Connect. By following these steps, you can streamline your workflow and enhance efficiency in managing image uploads and communications.
Ensure you check out Pabbly Connect to create business automation workflows and reduce manual tasks. Pabbly Connect currently offer integration with 2,000+ applications.
- Check out Pabbly Connect – Automate your business workflows effortlessly!
- Sign Up Free – Start your journey with ease!
- 10,000+ Video Tutorials – Learn step by step!
- Join Pabbly Facebook Group – Connect with 21,000+ like minded people!