Combine it with Google Sheets to automate data processing.
The following shows you how to use Bard to manage spreadsheets without formulas:
1. Take a screenshot of the data
Take a screenshot of the data table. Make sure to keep the column and row names on the screenshot.
Attention
There is no need to intercept the entire table. The purpose is to show the structure of the data.
2. Tip in Bard
Open Bard (bard.google.com) and paste the screenshot.
Then use this prompt template to perform the task that interests you:
“Act as a data analyst expert in writing macros for Google Sheets.
I have the following data format (see image) in a Google Sheets document. Write a JS macro for my Google Sheets document to [GOAL].
Think step by step to make sure the macro code will work. “
Target example:
“Sort athletes by height (Ht) and create a scatter chart with height and weight data for each athlete”
3. Import your macro
Copy the code from Bard and return it to your form.
- In “Extensions”, click “Apps Scripts”.
- Replace the existing code with your own and save it
- Return to extensions, macros, and import macros
- Click “Add Feature”
You may need to grant App Script permission, which is normal.
Step 4 Run the macro
Now all you have to do is go to the macro and run it.
- Go to Macro menu
- Click on the one you just imported
Google Sheets will handle the data for you!
If you make a mistake at this stage, don’t panic.
Just copy and paste the code into the conversation with Bard asking for a correction.
Just a few weeks ago, this kind of workflow was impossible on Bard. Gemini Pro and its recent optimizations have changed everything!
Original author @itsPaulAi
X original post: